Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help with coding a solution.
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
solution wants | Excel Discussion (Misc queries) | |||
Need a pop up solution! | Excel Discussion (Misc queries) | |||
"=ROW()-1" type of coding doesn't appear in a filter / is there coding that does? | Excel Programming | |||
Solution please | Excel Discussion (Misc queries) | |||
Best Fit Solution | Excel Programming |