Is it possible to use a formula in the middle of a sentence in exc
 

If so, how?

Is it possible to use a formula in the middle of a sentence in exc
 

Your question would be clearer if you wrote it in the body of the message,
added more detail explaining what you were looking to accomplish and
provided an example or two that showed what you were trying to do. I'll take
a guess that this might be what you are looking for...

="Some text"&<YourFormula&"and some more text"

For example, something like this example maybe (where I'm assuming Column A
contains a list of names)...

="There are "&COUNTA(A1:A100)&" people on the list"

--
Rick (MVP - Excel)


"krissy" wrote in message
...
If so, how?