ACT to Excel import with partial field

[shayne80]

Hello,
I'm trying to import from ACT into Excel. The field I want is "contact name". I would like to only import the first name. The field contains two or more names. "jane doe" or in some cases "jane & john doe".
Is there a way to eliminate the last name and get "jane" or "jane & john" only?

 

[Joe4]

Welcome to the Board!

You could use "Text To Columns" after the import to delete everything after the first space (use Space as a delimiter), or you could use a formula like this to pull everything up to the first space (assuming entry is in cell A1):
=LEFT(A1,FIND(" ",A1,1)-1)