Jump to content

Microsoft Excel Question


Recommended Posts

Posted

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

Posted

Try to enter this:

=concatenate("Total ... ",A32)

Posted

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?

Posted

try this

 

=CONCATENATE("Cost of ",B3, " jobs at ", B4, " sq. ft. ",)

Posted

SLW210,

 

Thanks but, Excel doesn't even recognize the cells. It recognizes all the text, though.

 

formula.jpg

Posted

Is there something in the cells? Worked fine here.

 

 

 

[ATTACH=CONFIG]31683[/ATTACH]

Posted

Yeah, there are formula's in the cell that I'm linking to.

Posted

It works for me when the cells being linked to are formulas.

Posted

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!

Posted

You can also use the Ampersand instead of Concatenate

Ampersand.jpg

 

Either way, whatever value that is in your field will end up in your text, not just the truncated value.

Posted

Thanks, gbradley. That's good to know and a lot easier to remember than Concatenablahblahblah...

Posted
You can also use the Ampersand instead of Concatenate
Good point, I noted that!

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.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...