Adding Two Text Fields together

A

Audrey

I'm using Office 2000. Is there a way to combined two "Text" cells into one
cell?

Ex. A1 text is "micro", A2 text is "soft, A3 = "microsoft".

Thank you for your time.
 
G

Gord Dibben

Audrey

In A3 enter =A1 & A2

When happy, you can copy A3 and Edit>Paste Special>Values>OK>Esc.

Clear Contents of A1 and A2 if you desire.


Gord Dibben Excel MVP
 
Top