Microsoft Excel Question

[bbankston]

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

[fuccaro]

Try to enter this:

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

[bbankston]

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?

[SLW210]

try this

 

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

[bbankston]

SLW210,

 

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

 

[SLW210]

Is there something in the cells? Worked fine here.

 

 

 

[ATTACH=CONFIG]31683[/ATTACH]

[bbankston]

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

[Organic]

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

[bbankston]

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!

[gbradley]

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.

[bbankston]

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

[fuccaro]

You can also use the Ampersand instead of Concatenate

Good point, I noted that!