I need to pull the first names and first initial of last name into a cell. In
cell g I have the first and last name (john doe). I need cell c to look at
cell g nad return only john d.

On Thu, 28 Feb 2008 10:30:06 -0800, krc547
wrote:

I need to pull the first names and first initial of last name into a cell. In
cell g I have the first and last name (john doe). I need cell c to look at
cell g nad return only john d.

Assuming the format is like what you show, then:

=LEFT(TRIM(G1),FIND(" ",TRIM(G1)))&MID(TRIM(G1),FIND(" ",TRIM(G1))+1,1)

--ron

=LEFT(G1,FIND(" ",G1)+1)
--
David Biddulph

"krc547" wrote in message
...
I need to pull the first names and first initial of last name into a cell.
In
cell g I have the first and last name (john doe). I need cell c to look at
cell g nad return only john d.

If some of the names have middle initials (ie, John Q. Doe), this formula
will work (works without the middle initial also):

=LEFT(G1,SEARCH(" ",G1))&IF(ISERROR(SEARCH(".",G1)), MID(G1,SEARCH("
",G1)+1,1), MID(G1,SEARCH(".",G1)+2,1))

Hope this helps,

Hutch

"Ron Rosenfeld" wrote:

On Thu, 28 Feb 2008 10:30:06 -0800, krc547
wrote:

I need to pull the first names and first initial of last name into a cell. In
cell g I have the first and last name (john doe). I need cell c to look at
cell g nad return only john d.

Assuming the format is like what you show, then:

=LEFT(TRIM(G1),FIND(" ",TRIM(G1)))&MID(TRIM(G1),FIND(" ",TRIM(G1))+1,1)

--ron