Remove Specify Char

[Tamiz1982]

Hi,
I am trying to remove last two characters which is start with "-".

I have column A Register No. like
587-A
145-B
638
155-C


I could removed only "-A". which i used below formula.

=IF(RIGHT(A2,2)="-A",LEFT(A2,LEN(A2)-2),A2)

Anyone help how to remove last two characters which is start with"-"

 

[Rick Rothstein]

Give this formula a try...

=LEFT(A1,FIND("-",A1&"-")-1)

 

[sandy666]

use Text2Columns with - as delimiter then select second column and choose : don't import column(skip)

Note: Hope there is Text to Columns in XL2007

 

[mehidy1437]

What i do in this case is, use replace method. Select the range & ctrl+H.
Find -* & Replace with nothing.

 

[Tamiz1982]

Give this formula a try...

=LEFT(A1,FIND("-",A1&"-")-1)

Yes its working.. Thank you very much.....
Thank You All... for your valuable reply..