Col A has first name & as well as some initials

Col B has last name

in Col C put this formula and drag it down

=IF(ISERROR(FIND(" ",A1)),A1,LEFT(A1,FIND(" ",A7)-1))

u well get only first name excluding the initials


On Dec 4, 12:26*am, GirlFridayCA
wrote:
Hi - need help again... *I have a large worksheet with a column for first
name and a column for last name. *Within the column for first name, some of
the names include a middle initial or middle name. *I need to remove all but
just the first name - there are over 3000 names and I don't have time to
manually do this task. *Is there a way to block the whole column and have
excel remove anything after the space following the first name?

Thanks!
--
Cali Gal
Native of Sacramento