You have a list of names that are inconsistently formatted (pretend there are 000's of names.) Because of this, you can't use the "text to columns" tool. Rather than retyping the list, you need to look at the patterns and figure out a way to determine the first and last names automatically using logical and string functions.

You have a list of names that are inconsistently formatted (pretend there are 000's of names.) Because of this, you can't use the "text to columns" tool. Rather than retyping the list, you need to look at the patterns and figure out a way to determine the first and last names automatically using logical and string functions.

The colum A labled Original was what I was given. I was able to use the tips to get the names broke down as much as I could, but I have reached a point that I am lost. I have to use a formula to pull the first name into colum H and last name into columa I. I know I can use the formual =concatenate(H5,"space",I5) to get the namec together for columa J. I am not lost on how to pull them from the information I do have in columa A thru G. All first name in colum H and all last names in columa I Thank You

1 Tip: If there is a comma in the cell, then the first name begins after the comma (and a space) and the last name is all of the characters up until the comma. There are many different text functions available sucl 2 First Name Last Name Full Name Comma Space 7 Aimee Brown Cynthia Critchard drew Longfellow, Andrew Longfellow, Andrew 0 Putterman, Ryan nson Olivia Olivia Jackson THOMPSON Jackson Thompson 36 Jackson THOMPSON