How do I insert a formula in a cell,which contains some text

You can have a formula or you can have some text. Can't be both at the same
time, although a formula may generate text.

Tell us more about what needs to be in that cell during different situations
and maybe we can work out a solution.

"Smitha Roney" wrote:

How do I insert a formula in a cell,which contains some text

Use the N Function

Eg. =1500+N("This was paid in May")+500+N("This was Paid in June")

Will give you 2000
IS this what you are looking for


"JLatham" wrote:

You can have a formula or you can have some text. Can't be both at the same
time, although a formula may generate text.

Tell us more about what needs to be in that cell during different situations
and maybe we can work out a solution.

"Smitha Roney" wrote:

How do I insert a formula in a cell,which contains some text

OR Is this what you are looking for?

Example: ="Date of Issue: "&TEXT(TODAY(),"dd-mmm-yy")
Result: Date of Issue: 09-Jul-07



"claude jerry" wrote:

Use the N Function

Eg. =1500+N("This was paid in May")+500+N("This was Paid in June")

Will give you 2000
IS this what you are looking for


"JLatham" wrote:

You can have a formula or you can have some text. Can't be both at the same
time, although a formula may generate text.

Tell us more about what needs to be in that cell during different situations
and maybe we can work out a solution.

"Smitha Roney" wrote:

How do I insert a formula in a cell,which contains some text

Very good example, from you and Qull666 - that's kind of what I had in mind
when I said there could be a formula that returns some text - also, possibly
and IF() statement. Just depends on description the OP provides back to us
of the exact need.

"claude jerry" wrote:

Use the N Function

Eg. =1500+N("This was paid in May")+500+N("This was Paid in June")

Will give you 2000
IS this what you are looking for


"JLatham" wrote:

You can have a formula or you can have some text. Can't be both at the same
time, although a formula may generate text.

Tell us more about what needs to be in that cell during different situations
and maybe we can work out a solution.

"Smitha Roney" wrote:

How do I insert a formula in a cell,which contains some text

if you want just a display of a number with text,
="text"&formula()
if you want it to act as a number, use custom formating but you have to add
the text in the custom format.

"Smitha Roney" wrote:

How do I insert a formula in a cell,which contains some text