Azhar Hussain asked from Pakistan

I have a list of part numbers in excel (36,000 lines)
I need to remove word Count from the whole list as well as want to make sure that initial 2 zeros should not be removed.

For Example.
Pls remove "Count" but make sure that first 2 zeros "00" should not be removed or deleted.
00-0004
00-0005 Count
0-001 Count
0006648-801 Count
00083-002 Count
00131-022-005 Count
0013374 Count
0013879 Count
0013888 Count
0013889-15 Count


Solution:

Dear Azhar Hussain,

You can do it easily by using the "LEFT" function available in Excel. Follow the steps below:

Step 1: click on the cell just after the first cell of the list of numbers.

Step 2: write "=LEFT(A2, LEN(A2)-5)", where "A2" is cell reference and "-5" is the number of characters you wish to erase from the field.

Step 3: copy the formula down the cells till the list ends.