I have Fname in A and Lname in B. I want to combine the 2 cols.

[noreagaxl]

I have Fname in A and Lname in B. I want to combine the 2 cols. How do
do that? Thank you

 

[Frank Kabel]

Hi
one way: Enter the following in C1
=A1 & " " & B1
copy down

 

[noreagaxl]

What if I wanted to combine a1 b1 c1 d1 ?

 

[Frank Kabel]

Hi
=A1 & " " & B1 & " " & C1 & " " & D1
alse separated by a space

 

[noreagaxl]

Thank you for your help and advice