one way:
=mid(a1,find("-",a1)+1, 256)
HTH
"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