EASY EXCEL ? USING THE CONCATENATE (&) FUNCTION 2

[jcthomas]

I need a little guidance in using the (&) function what i'm trying to do is combine 2 text fields into one. column J is last name column k is first name I need to combine into one field. Can someone help me please. Thanks in advance. This is office 2000 excel.

 

[Zathras]

If J1 = 'Smith
and K1 = 'John
then one of the following formula might be used:
[tt]
=K1&" "&J1 (For "John Smith")
=J1&", "&K1 (For "Smith, John")
=K1&J1 (For "JohnSmith" which you probably don't want.)
[/tt]

 

[firefytr]

=K1&" "&J1

or

=J1&" "&K1

If you want to leave static values, copy the cells, Edit | Paste Special | Values | Ok.

HTH

-----------
Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a Microsoft MVP?
- Leonardo da Vinci

 

[jcthomas]

Thanks Zathras, that worked.

Now I have another problem I need to replace those columns with the one I have created using that formula, and of course cut and paste doesnt work. Any advice. Thanks in advance.

 

[Zathras]

Zack was posting the answer at the same time you were posting the new question:

Use Edit/Copy/Paste Special/Values to replace the formulas and then you can either delete the original column or copy and paste over it.

 

[jcthomas]

Yeah that was some good timing thanks to both of you I have it all done. Thanks again..

 

[firefytr]

Glad to help.

-----------
Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a Microsoft MVP? Professional Office Developers Association
- Leonardo da Vinci