Remove all characters before & including a dash

[android1]

Hi,


My cell A4 contains the text 103-6807-2016-11-25 -CL- Joesep Byrne Senior -ST- Grace Jones.html


I want to remove everything before & including the first -


Also, other cells will have more than 3 characters before the 1st - taht I need to remove.


Been trying this but can't get it to work - =RIGHT(A4,LEN(A4-FIND("-",A4,1)))


Gerry

 

[MrKowz]

You're close with that formula. Try:

Excel 2013/2016
	A
1	103-6807-2014-11-25 - CL- Josep Byrne Senir -ST- Grace Jones.html
2	6807-2014-11-25 - CL- Josep Byrne Senir -ST- Grace Jones.html
Sheet1

Cell Formulas
Range	Formula
A2	=RIGHT(A1,LEN(A1)-SEARCH("-",A1))

 

[Scott T]

Try

=TRIM(MID(A4,SEARCH("-",A4)+1,LEN(A4)))

 

[android1]

You're close with that formula. Try:

Excel 2013/2016

	A
1	103-6807-2014-11-25 - CL- Josep Byrne Senir -ST- Grace Jones.html
2	6807-2014-11-25 - CL- Josep Byrne Senir -ST- Grace Jones.html

<colgroup><col style="width: 25pxpx"><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula A2 =RIGHT(A1,LEN(A1)-SEARCH("-",A1)) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

That works perfectly. Thank a lot.

 

[android1]

Try

=TRIM(MID(A4,SEARCH("-",A4)+1,LEN(A4)))

That works too. Thank you.