Hi,

Select the column and choose Data, Text to Columns, Delimited, click Next
and indicate Space, click Next and highlight all columns in the Preview pane
which you don't want and click Skip (do not import).

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"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