At the end of every week I get a report from Peachtree that shows sales
commissions by sales rep. Sales sometimes have two reps involved.
Unfortunately Peachtree only has one field to track a sales rep. So
many line items in the report have one cell with two reps names in it,
like this Rep1/Rep2 or JamesJ/TinaS.

For reporting purposes I need to separate the reps names into separate
cells, so JamesJ/TinaS becomes a cell with JamesJ in one cell and TinaS
in another.

Is it possible to write code that would split out anything before and
after the "/" into two other cells?

Thanks in advance for the help, it's greatly appreciated.

Steve M.