keeping text superscripted when merging it with text

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
 
G

Geoff

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Superscripting text in a cell 1
retaining font format after text merge 1
How to prevent the line break between superscripts? 5
Superscripted cross-refs change to regular font size? 3
Superscripting Ordinals that are not Superscripted 4
Column Merging 1
Excel 2002: Merging cell content with a comma seperattor 2
merging worksheets into an overall report 3

Top