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
103-6807-2014-11-25 - CL- Josep Byrne Senir -ST- Grace Jones.html
6807-2014-11-25 - CL- Josep Byrne Senir -ST- Grace Jones.html

<colgroup><col style="width: 25pxpx"><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]A2[/TH]
[TD="align: left"]=RIGHT(A1,LEN(A1)-SEARCH("-",A1))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

That works perfectly. Thank a lot.

 

[android1]

Try

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

That works too. Thank you.