[diggeryo]

Is it possible to put text and a formula into the same cell? My mind reverted back to my old Pascal ways and I tried commas and apostrophes, but can't seem to get it to work.

Any help is appreciated.

thanks,
mike.

[Advertisements]

Hi Mike,

Sorry to tell you that no it is not. If you put a formula into a cell, it can be the only thing in that cell. Any words that you put in front on the start of the function or at the end of the function will null the function, and you will end up with something like "Dockboy=SUM(A4+B4)" showing in the cell. But you probably already know that. You will have to resort to the words being in the cell beside the formula cell. Just how it works. Sorry.

Cheers:)

[Dockboy]

Hi Mike,

Sorry to tell you that no it is not. If you put a formula into a cell, it can be the only thing in that cell. Any words that you put in front on the start of the function or at the end of the function will null the function, and you will end up with something like "Dockboy=SUM(A4+B4)" showing in the cell. But you probably already know that. You will have to resort to the words being in the cell beside the formula cell. Just how it works. Sorry.

Cheers:)

[diggeryo]

I figured as much, since I couldn't find help on it anywhere. Thanks for the quick heads up.

[Dockboy]

No problemo

[Retired Tech]

Can you put an example of what you want in one cell

[Dockboy]

Keith,

Although your solution is a correct answer, it was not what he was looking to do. He wanted to have text and a formula within one cell.

I do not mean any disrespect to you in any way, I just thought I should point out what he was asking, in case you had interpreted it wrong.

All the best

Cheers:)



*I see you just changed your post when I posted my response. No worries then. Cheers:)

Edited by Dockboy, 18 April 2006 - 02:58 PM.

[Retired Tech]

I just wondered if using shrink to fit or enlarging the cells was it, then decided it couldn't be that easy, so changed the response I was probably changing it while you were posting yours

[dsm]

Mike,
I was a bit confused by the trail of responses and exactly what you wanted to do. It is definitely possible to combine text and formula in a cell as in the following example.

="Dockboy " & SUM(A4:B4)

HTH
David