keeping text superscripted when merging it with text

  • Thread starter Thread starter ivan
  • Start date Start date
I

ivan

I am merging two cells with the =text function. The first
part of the merge is a number and the second part is a
superscripted statement. How can I (without using a macro)
make the superscript stick?

thanks in advance,
Ivan
 
Ivan,

If i have understood your question correctly, say in Cell
A1 you have 124, and B1 Big Street, and you are trying to
merge them, the formula =value(A1)&(B1) will tie the two
together.

Regards
 
Back
Top