software

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 quot;text to columnsquot; 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