here's what i have to figure out, with your help.
i have a list:
A colm Bcolm
order a delivered 10/10/06
order b delivered 10/09/06
order c in transit 10/10/06
order d in transit 10/11/06
I want to take this list and put them in a pivot table, but i only want to select either in transit or delivered.
is there a way to seperate the delievered and in transit form the rest of the contents of the cell?
I can't use =left() because the length of info to pull differs.
help!
i have a list:
A colm Bcolm
order a delivered 10/10/06
order b delivered 10/09/06
order c in transit 10/10/06
order d in transit 10/11/06
I want to take this list and put them in a pivot table, but i only want to select either in transit or delivered.
is there a way to seperate the delievered and in transit form the rest of the contents of the cell?
I can't use =left() because the length of info to pull differs.
help!