Concatenate with superscript

[mbaue002]

I am trying to concatenate two cells, one of which has a superscripted number in front as part of a footnote. Is there anyway to keep a superscripted number in a concatenated cell? I already tried hardcoding the number into the formula and editing it, but that does not work.

 

[noboffinme]

Hi mbaue002,

The below link deals with this situation using VBA, it's the only solution I'm aware of.

http://www.mrexcel.com/forum/showthread.php?t=488988

 

[spikepl]

muck-spreader

 

[noboffinme]

????

Do you have an issue with this answer ??

If so, let me know why, I don't propose to know everything so it may help.

If not, save your effort for something constructive ...