software

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

Hi!

Try this:

A1 = Joe
B1 = George
C1 = Thomas

=A1amp;quot; quot;amp;B1amp;quot; quot;amp;C1

Biff

quot;Joequot; gt; wrote in message
...
gt;i have a small doubt. If suppose i entered my full name, Joe George Thomas,
gt; in 3 columns and if i want to merge those all three to one single column,
gt; and
gt; read that as a full name, how can i do that?
gt; Thanx n rgds
gt; joe
=A1 amp; quot; quot; amp; B1 amp; quot; quot; amp; C1 entered in D1

When happy with the results you may want to copy D1 and paste special(in
place)gt;valuesgt;okgt;esc

You can clear A1, B1 and C1Gord Dibben MS Excel MVP

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

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