Hi,
I'm using Excel to convert relatively unformatted text into something more
structured. My problem is specifically with converting a full name into
separate fields. The data looks something like:
Smith, Sam S
Jones_ Jim J Jr.
Taylor Tom T.
Neat Ned
Friendly, Dr

You get the picture.
It doesn't matter to me if I use VB or a worksheet formula, or some other
mechanism. This can't be the first time that anyone has converted
concatinated names into seperate fields. Any advice?
--
Programmer on Budget