View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default 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