Hello All,
I have a spreadsheet that I export from another program for my inventory part numbers. When the part number comes in to Excel, it also comes in with a description in the same cell.

Example:
7001456 (15A GFCI, white)
4563289WL (Double bowl kitchen sink)
123456F (Test item)

I need a formula that will just delete (or replace) everything after the last character in the item number (basically at the space between the last character and the "(" ). Is this possible with Excel?

I create another column next to this one for barcodes and then do a mail merge so I can't have the whole description with the part number. Ironically, the cell to the right of the part number has the exact same description, less the number!

Any ideas would be greatly appreciated ;-)

-Brian