parsing text

[ellee]

I would like to divide a text string into separate columns.
Example:

Text Strings
smith_p smith, paul d (Acme)
jones_a jones,art
barnes_s barnes, sam (TPA)

Column results
Last Name First Name MI Company
********************************************
Smith Paul D Acme
Jones Art
Barnes Sam TPA

The first piece of data is not needed. The names may or
may not have a middle initial and/or company. Text-to-
Columns does not give the desired result.

Thanks for any help you can give me.

 

[Earl Kiosterud]

Ellee,

Seems I saw a macro that will do that at www.cpearson.com. Can't seem to
find it now, so not sure.