bbankston Posted December 13, 2011 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
fuccaro Posted December 13, 2011 Posted December 13, 2011 Try to enter this: =concatenate("Total ... ",A32) Quote
bbankston Posted December 13, 2011 Author 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
SLW210 Posted December 13, 2011 Posted December 13, 2011 try this =CONCATENATE("Cost of ",B3, " jobs at ", B4, " sq. ft. ",) Quote
bbankston Posted December 13, 2011 Author Posted December 13, 2011 SLW210, Thanks but, Excel doesn't even recognize the cells. It recognizes all the text, though. Quote
SLW210 Posted December 13, 2011 Posted December 13, 2011 Is there something in the cells? Worked fine here. [ATTACH=CONFIG]31683[/ATTACH] Quote
bbankston Posted December 13, 2011 Author Posted December 13, 2011 Yeah, there are formula's in the cell that I'm linking to. Quote
Organic Posted December 14, 2011 Posted December 14, 2011 It works for me when the cells being linked to are formulas. Quote
bbankston Posted December 14, 2011 Author 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
gbradley Posted December 15, 2011 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
bbankston Posted December 15, 2011 Author Posted December 15, 2011 Thanks, gbradley. That's good to know and a lot easier to remember than Concatenablahblahblah... Quote
fuccaro Posted December 15, 2011 Posted December 15, 2011 You can also use the Ampersand instead of ConcatenateGood point, I noted that! Quote
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.