If your data is in column A, starting in row 1, then in B2 enter the formula
=right(a2,len(a2)-4. Autofill that formula down through the entire column.
If you only want to keep that trimmed value, you can copy/paste special
values, then delete column A.
Once that's done, click a single cell in your table and go to Data Filter
Autofilter. Select the drop-down in the column with the trimmed data and
choose 'Custom'. Use the first drop-down in that dialog to select 'Does Not
Contain' and type B in the top-right text box. Hit OK.
"koba" wrote:
Dear All
I have a problem could somebody please help?
I have a list of data and I would like to filter it buy removing the
first 4 characters
DHK-6000
DHK-6000.
DHK-6000HD
DHK-6000HDB
SZK-6001
SZK-6001.
RVK-6002
RVK-6002.
To make it look like this
6000
6000.
6000HD
6000HDB
6001
6001.
6002
6002.
As I have thousands of these I do not want to do this manually
Also once I have done this how do I filter the data so that it does not
display any data containing a B.
Answers to either question would be much appreciated.
Thanks
Andrew
--
koba
------------------------------------------------------------------------
koba's Profile: http://www.excelforum.com/member.php...o&userid=28639
View this thread: http://www.excelforum.com/showthread...hreadid=483692