How do I insert code to generate formula?
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.