post #1 of 1
Thread Starter 

Hi,

 

Pretty new at Numbers and spreadsheets.

 

One of my columns is for full name, but I need to extract the first name and place it in a new column. This will allow me to create a CSV file and import into my mailing program and be able to address the individuals by their first name. I have about 1,000 customers.

 

I found the following formula on Apple Support:

 

=IFERROR(LEFT(TRIM(B2),SEARCH(" ",TRIM(B2))-1),IF(ISBLANK(B2),"",TRIM(B2)))

 

What I don't know is how and where to insert this to make it effective.

 

Can you give me a step-by-step on what to highlight, what to type in, etc?

 

Thanks.