merging some data in 2 columns
 

I have a column titled first name
I also have a column titled last name.

I wish to merge this data but only some of it.

I wish to end up with a first initial (space) last name column and all the
data as such.

merging some data in 2 columns
 

One way

=LEFT(A1)&" "&B1



--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com



"Karla" wrote in message
...
I have a column titled first name
I also have a column titled last name.

I wish to merge this data but only some of it.

I wish to end up with a first initial (space) last name column and all the
data as such.