Mixing Numeric & Text Formats

[ice1000]

I have an Excel user that needs to mix a formula with text. The tricky part is that the formating is on a cell that contains a formula and the text formatting needs to be as a subscript.

I know you can do this:

=sum(A1:A10)&"d"

but the user wants the d to appear as a subscript (in the same cell as the formula). I advised her to put it in the cell next to it but she wants to know if it is possible to have it in the same cell.

I don't think it is possible to do since you are mixing data formats. I looked into the text function but the formats specified are for numbers, not text. Additionally, I don't think you could add a text character and still be able to add the numbers.

What do you all think? Possible or not possible?

 

[jindon]

I don't think it is possible to do since you are mixing data formats. I looked into the text function but the formats specified are for numbers, not text. Additionally, I don't think you could add a text character and still be able to add the numbers.

What do you all think? Possible or not possible?

What you think is correct.

You can only do it constant and string.
So you need to convert it into a text value before you do.