Start a new topic

Parsing out First, Middle and Last name from single Field


I'm trying to import PayPal data from a CSV. The donor name comes in as a single field. Since this is donor supplied data there isn't a set pattern of data -- for instance some people gave first and last while other added middle names, suffixes and other such things. Text to column leaves subsequent columns with a mixture of some middle names and some last names. Using the excel function of typing the first word or last word to create a pattern does not accommodate hyphenated last time, suffixes and we'd middle name all together.

 My last hope is that somehow a regular expression could help? Does anyone have an experience with this? Thank you!

1 person has this question
Login or Signup to post a comment