Hi,

In many case the best way to break up data that is in single cell (column)
into two or more cells is to use the Text to Columns Wizard.

1. Select a single column of cells which you want to split.
2. Choose the command Data, Text to Columns,
3. Choose Delimited and click Next
4. Choose one of the delimiter or define one of your own in the Other box,
and then click Next
5. In many cases there is nothing you need to do at this step, so just click
Finish.

In your case run the command once and choose Fixed Width on the first
screen, on the second screen click between the 5th and 6th character and
click Finish.

Then select the second column of data, which now contains the other two
pieces of information and repeat the Text to Columns command but this time
choose Delimited and on the next screen enter / in the Other box and click
Finish.

If this information helps, please click the Yes button.

Cheers,
Shane Devenshire

"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.