Excel Removing the last 7 characters of cell in excel

N

ne1lfin

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:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Last Modified By in a cell by user 3
Excel Formula Help 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Some Cells display text others dates in the same column 2
return the price of an item in a cell 2
'RIGHT', 'LEFT' in a VLOOKUP 6
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel Excel Vlookup formula based on cell data 7

Top