Excel

news.microsoft.com · Jun 6, 2005

If I have a cell that contains a person's full name, how do I get just their
first name in another cell.

Thanks,
Mike

Harald Staff · Jun 6, 2005

Hi Mike

=LEFT(A1,FIND(" ",A1)-1)

HTH. Best wishes Harald

news.microsoft.com · Jun 6, 2005

Thanks Harald!

Harald Staff said:
Hi Mike

=LEFT(A1,FIND(" ",A1)-1)

HTH. Best wishes Harald