Merge words in diff cols to one
 

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

Merge words in diff cols to one
 

Hi!

Try this:

A1 = Joe
B1 = George
C1 = Thomas

=A1&" "&B1&" "&C1

Biff

"Joe" wrote in message
...
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

Merge words in diff cols to one
 

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

When happy with the results you may want to copy D1 and paste special(in
place)valuesokesc

You can clear A1, B1 and C1


Gord Dibben MS Excel MVP

On Sun, 22 Jan 2006 22:04:02 -0800, Joe wrote:

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