software

Hi,

How can I make this happen.

A1=10oC
A2= /-
A3=1oC

Z1 cell contains the formula: A1amp;A2amp;A3 and displays: 100C /-10C

I want the superscript of the degrees in cell A1 to be in Z1 but I dont
know the text=() format to achieve this.

Thanks in advance,

Slash.There are two methods of using these special symbols:

First one is using Character Map from the System Tools and then copying and
pasting specialy symbols as desire.

The easiest method is using shortcut key:

For example, when you want to use type degree sign for 10oc
press ALT 0176 key like this 10°c
press ALT 0177 key like ±

Hope this will help. Let us know.

quot; wrote:

gt; Hi,
gt;
gt; How can I make this happen.
gt;
gt; A1=10oC
gt; A2= /-
gt; A3=1oC
gt;
gt; Z1 cell contains the formula: A1amp;A2amp;A3 and displays: 100C /-10C
gt;
gt; I want the superscript of the degrees in cell A1 to be in Z1 but I dont
gt; know the text=() format to achieve this.
gt;
gt; Thanks in advance,
gt;
gt; Slash.
gt;
gt;

Hi thanks for that, it has shown me something new and nifty in excel I
didnt know before, and it works well.

Thanks alot,

Slash.