Extracting certain text from cells

[ajbettencourt]

I am working in a marketing project and have a spreadsheet containing names and addresses for a direct mail product. Presently, there is one column that contains each recipients full name (ex. John P Smith). I would like to create a new column next to the name column, and populate the cells with just the recipient's first name (or, the text that appears prior to the first space in the name field). I would appreciate any help that could be offered.

Thank you.
John

[Ace_XL]

Try..

Data--text to Columns --Delimited by --Space

or simply
=Left(A1,find(" ",A1)-1)