Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Parsing a name
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Parsing | Excel Discussion (Misc queries) | |||
Instead of Parsing | Excel Discussion (Misc queries) | |||
Parsing Data | Excel Programming | |||
Parsing paramters | Excel Programming | |||
Parsing help | Excel Programming |