You may need to do a bit of preperation on your cells for this to work, by
using the replace option in Excel.
Use the replace option to replace the Hyphen " - " with a comma " , "
Highlight all the cells then Data/Text to Columns, Delimited checked/Next.
"Tab" checked "Comma" checked "Other" checked then type a "/" into the box.
Next/ Finish.
A problem arises with these lines "MT- OR/RN / Billings Clinic" and "IA -
ASAP MedSurg/Float Nurse/Nights / Allen Hospital" because "OR", "RN" and
"Float Nurse","Nights" appear in seperate columns.

OK Interim OR Director Southwestern Medical Center
IA ASAP MedSurg Float Nurse Nights Allen Hospital
AZ ICU (URGENT) Tuba City Regional
MT OR RN Billings Clinic
CO RN OR Eve shift Medical Center of the Rockies


Apart from these it works great.

"Pat" wrote:

I have a file that I'm getting from an source, the first field contains a
field like this:

OK - Interim OR Director / Southwestern Medical Center
IA - ASAP MedSurg/Float Nurse/Nights / Allen Hospital
AZ - ICU (URGENT) / Tuba City Regional
MT- OR/RN / Billings Clinic
CO - RN OR Eve shift / Medical Center of the Rockies

Each line represents one cell. My problem is that I need this data
transformed some how in to three fields. State, Position, Facility (which is
the order and information contained in the cell).

Any thoughts, suggestions? Thanks in advance for your help.