delimiting w/multiple delimiters?
 

I have a large database I use that has our item numbers and quantities in the
same cell (example: PRODUCTA Q100, and PRODUCTA Q200, etc). It works for me
to use the quantities for formula later by doing the "text to columns" and
delimiting by Q. Problem is, sometimes the product name also has a Q in it
so the delimiting function seperates it incorrectly. Like:

Works:
cell A: PRODUCTA Q100
turns to--
cell A: PRODUCTA cell B: 100

Doesn't work when:
cell F: PRODUCTQA Q100
turns to--
cell A: PRODUCT cell B: A cell C:100

The LAST Q# is always the one I want to seperate out. Is there a formula I
can tell it to just take out the last one?

Thanks,

Nicki

--
Nicki Taylor