Merge words in diff cols to one

J

Joe

i have a small doubt. If suppose i entered my full name, Joe George Thomas,
in 3 columns and if i want to merge those all three to one single column, and
read that as a full name, how can i do that?
Thanx n rgds
joe
 
G

Gord Dibben

=A1 & " " & B1 & " " & C1 entered in D1

When happy with the results you may want to copy D1 and paste special(in
place)>values>ok>esc

You can clear A1, B1 and C1


Gord Dibben MS Excel MVP
 
Top