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!
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: