Merge words in diff cols to one

[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

[Biff]

Hi!

Try this:

A1 = Joe
B1 = George
C1 = Thomas

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

Biff

"Joe" <joe@discussions.microsoft.com> wrote in message
news:89EACA06-9BCA-47EB-BC48-09CFE24DCB54@microsoft.com...
>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

[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

On Sun, 22 Jan 2006 22:04:02 -0800, Joe <joe@discussions.microsoft.com> 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