Search code examples
excelvbaexcel-formulaexcel-2019

excel concatenate with "²" or squared symbol

I would like to use a concatenate formula in Excel that also includes the superscript number 2 (squared symbol), but this does not work with the following input. The formula is roughly like this:

=CONCATENATE("13";"²")

i want to get an output like this:

13²

I tried using superscript functions on the font but it didn't work when the text is inside the concatenation.

I have to use concatenate because I want to automate.

Is it possible to do with Excel 2019 there? or is it possible but would require VBA?

Solution

  • Try =CONCATENATE("13";CHAR(178))