Please modify Autocorrect in Excel 2016 to allow formated entries
Word 2016 Proofing Autocorrect allows us to replace typed text with formatted text. This allows easy addition of eg, m2, km2 etc with superscripted numbers. In Excel there is no option for this. Though formatted text can be inserted by copying from the Character Map and pasting. Few users would know this. Please fix.
It would also be useful if Autocorrect entries in Word could be applied to Excel as I believe was once the case, but now doesn't seem to work.
Kenneth Barber commented
The superscript 2 (²) in the Character Map is an actual unformatted character, but you don't have to go that far to get it. In Excel, go to the Insert tab and then Symbols. The ² character is near the top. Insert it into your sheet and copy it from there.