Need help with coding a solution.

S

smonczka

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.
(e-mail address removed)
 
M

Mayank Prakash Gupta

try using data>text to columns>>next.....set delimiter as "/" and it will be
done....the only catch is that the original coluimn will be deleted and two
new columns will be made...so in case u want to preserve the original
column, make a copy of that column and perform the operation on it.

hope it helps

MPG
 
S

smonczka

Mayank, thanks that would be exactly what I was looking for. Deleteing
the original row would not be a problem. But I'm new to writing code
could you give me an example of what you are talking about. I've never
heard of DATA>TEXT functions?

Thank you,
Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top