Excel Removing the last 7 characters of cell in excel

Joined
Aug 4, 2011
Messages
1
Reaction score
0
Hello,
I'm updating a price sheet with about 35,000 items in excel. Our price sheet consists of the manufacturer part number followed by an underscore and then our SKU number; " RW115_100080 " for example.

We are trying to remove the SKU number from all the cells in the SKU column.

Is there a macro which would allow us to remove only the last 7 characters of all cells in column B? All the SKU numbers and the underscores need to be removed for all 35,000 items. The formula should remove only 7 characters from the right on all cells in column B. I started removing them manually which has proven to be extremely time consuming! any help would be greatly appreciated!!


Thanks!
 
Last edited:
Back
Top