Thanks Frank,

The company I work for outputs specifications from a database, I'd like
to break out chunks of text from the string. e.g.

1......STPTLA-0091 - Strap Toggle Assembly with Locking Clevis Pin -
0091 (MANUFACTURED)1(1)

All I need is the part number STPTLA-0091 in one cell and the
description, Strap Toggle Assembly with Locking Clevis Pin, in another.
I can do this useing a nested funtion in Excel but it's very cumbersome.

Regards,

Simon Corner


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!