How to remove unique characters (numerical & alphabet) in a cell

[yakooza]

Hello Guys,

I am a new guy here and I would like to ask to all sifus and experienced people, how can I remove character for example:

-61BRE6195L to become BRE6195L

-132339359L to become 339359L

-2AN25-21 to become AN25-21

Your kind help is much appreciated.

Thanks in advance.

 

[Sam_D_Ben]

Excel 2007
	A	B
1	Example	Result
2	-61BRE6195L	BRE6195L
Sheet2

Cell Formulas
Range	Formula
B2	=RIGHT(A2,LEN(A2)-3)

Hope this help..Muz..

 

[yakooza]

Thanks Muzama Christo, you are the best!