Adding Two Text Fields together
 

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.

Hi!

=A1&A2

OR

=CONCATENATE(A1,A2)

Biff

-----Original Message-----
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.

.

Audrey

In A3 enter =A1 & A2

When happy, you can copy A3 and EditPaste SpecialValuesOKEsc.

Clear Contents of A1 and A2 if you desire.


Gord Dibben Excel MVP




On Thu, 24 Feb 2005 11:51:04 -0800, Audrey
wrote:

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.