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.

One way

=LEFT(A1)&" "&B1



--


Regards,

Peo Sjoblom

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



"Karla" <Karla@discussions.microsoft.com> wrote in message
news:45F3B5A8-21B6-4A71-BBA4-A1FDCD8624D1@microsoft.com...
>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.