If-then statements - searching through text

[joeycg]

Hi,

I am hoping someone can help me with my job of managing e-mail lists. Some lists have first and last names already separated, but some have both first and last names in a single cell. I was hoping to write an if-then statement to help separate first and last names in these cells. The way I imagine it working is that it would loop through the cell searching for characters, cut once it finds a space, and copy the first name into a separate column.

I only have elementary coding experience, so while I feel like this could be done, I have no idea how to execute. I am using Excel 2011 for Mac. Thanks for your time and patience.

Joey

 

[Ron Coderre]

Before we can offer case specific alternatives, we'll need you to list every name combination type.
Examples:
A1: Firstname
B1: Lastname

A1: Firstname Lastname
B1: (blank)

A1: Lastname,Firstname

A1: Lastname, Firstname
etc.

 

[joeycg]

Ron, thanks for getting back to me.

It currently reads:
A1: Firstname Lastname
B1 is currently blank.

I am hoping to automate a process so that it reads:
A1: Firstname
B1: Lastname

 

[joeycg]

The issue was solved using the Text to Columns tool. Thanks for the help and I apologize for the novice post.