reading a partial string in Excel

[chadlmiller]

Ok I am using Excel 2007 and here are the examples of what I need.
in the column I have data example:
03 - Maintenance & Production Facilities
02 - Training Facilities

I want to read the text of the first two identifiers 03, 02 and store it into a new column seperate rows. I plan to delete the old column with the combined text. I have a similiar istance of a field example:

141-179

I need to read the string 141 and store it separately as its own string.

Thank you for any help,
Chad Miller

 

[mintjulep]

Data | Text to columns will probably do what you want.

Or some combination of LEFT() and FIND().