bbankston Posted December 13, 2011 Share Posted December 13, 2011 Hopefully you guys can help... In a single cell in Excel I want to be able to have a sentence and data from another cell. For example: Total sq. ft. used A32 A32 has a SUM formula adding up all cells in a row on another sheet. Thanks, Brandon Quote Link to comment Share on other sites More sharing options...
fuccaro Posted December 13, 2011 Share Posted December 13, 2011 Try to enter this: =concatenate("Total ... ",A32) Quote Link to comment Share on other sites More sharing options...
bbankston Posted December 13, 2011 Author Share Posted December 13, 2011 fuccaro, Awesome! It works to an extent. This works: =CONCATENATE("Cost of ",B3) This doesn't work: =CONCATENATE("Cost of ",B3 "jobs at" ,B4 "sq. ft.") Help? Quote Link to comment Share on other sites More sharing options...
SLW210 Posted December 13, 2011 Share Posted December 13, 2011 try this =CONCATENATE("Cost of ",B3, " jobs at ", B4, " sq. ft. ",) Quote Link to comment Share on other sites More sharing options...
bbankston Posted December 13, 2011 Author Share Posted December 13, 2011 SLW210, Thanks but, Excel doesn't even recognize the cells. It recognizes all the text, though. Quote Link to comment Share on other sites More sharing options...
SLW210 Posted December 13, 2011 Share Posted December 13, 2011 Is there something in the cells? Worked fine here. [ATTACH=CONFIG]31683[/ATTACH] Quote Link to comment Share on other sites More sharing options...
bbankston Posted December 13, 2011 Author Share Posted December 13, 2011 Yeah, there are formula's in the cell that I'm linking to. Quote Link to comment Share on other sites More sharing options...
Organic Posted December 14, 2011 Share Posted December 14, 2011 It works for me when the cells being linked to are formulas. Quote Link to comment Share on other sites More sharing options...
bbankston Posted December 14, 2011 Author Share Posted December 14, 2011 Your code worked, SLW210. For some reason it didn't like where I originally put it but when I moved it - then moved it back - it worked fine. Weird. Thanks for the help! Quote Link to comment Share on other sites More sharing options...
gbradley Posted December 15, 2011 Share Posted December 15, 2011 You can also use the Ampersand instead of Concatenate Either way, whatever value that is in your field will end up in your text, not just the truncated value. Quote Link to comment Share on other sites More sharing options...
bbankston Posted December 15, 2011 Author Share Posted December 15, 2011 Thanks, gbradley. That's good to know and a lot easier to remember than Concatenablahblahblah... Quote Link to comment Share on other sites More sharing options...
fuccaro Posted December 15, 2011 Share Posted December 15, 2011 You can also use the Ampersand instead of ConcatenateGood point, I noted that! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.