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.
August 21, 2006 at 5:21 pm
I’ll say it again… Excel is one of the most powerful and underutilized programs available.