Parsing Names in Excel

I was in need of parsing out the first, middle, and last names from a single field in Excel. The following site had the formulas necessary in order to make this happen: ITS Software Tip – 04/29/02 – Parsing Names in Excel. Note there is one problem, the coded listed for last name parsing on the site is wrong, but if you download the example and use the code there it works great.

In my case I had some additional problems that required some massaging of the data prior to using the functions. My name field not only had First, Middle, and Last names it also had title and suffix too. Once I cleaned those up the formulas worked great.

Advertisements
Previous Post
Leave a comment

1 Comment

  1. I’ll say it again… Excel is one of the most powerful and underutilized programs available.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: