Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,564
- Office Version
- 365
- 2016
- Platform
- Windows
What do I need to do to use the concatenate function to take two cells of data:
A1 = 42
B1 = 13.56
to get this result 42O13.56 ... where O is superscripted to indicate degrees?
I have the basics ...
, but how would I format the "O" to be superscript?
A1 = 42
B1 = 13.56
to get this result 42O13.56 ... where O is superscripted to indicate degrees?
I have the basics ...
Code:
=concatenate(A1,"O",B1)
