Extract data from one cell into another, but FIND character is one of two choices

[jblyx002]

[TABLE="width: 196"]
<tbody>[TR]
[TD]I'm trying to extract everything after the L or R (at the end) of the cell below into another cell.[/TD]
[/TR]
[TR]
[TD][TABLE="width: 196"]
<tbody>[TR]
[TD]
Column D[/TD]
[/TR]
[TR]
[TD]GL 480+32.2L32[/TD]
[/TR]
[TR]
[TD]GL 489+01.3L32.1[/TD]
[/TR]
[TR]
[TD]GL 2+00R32[/TD]
[/TR]
[TR]
[TD]GL 3+00R32.5[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]so that Column E will show
L32
L32.1
R32
R32.5[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]

 

[cmduong_vn]

Welcome to the MrExcel board!

If that idea works, and it very well might given the samples quoted, then this shorter version should also.

=MID(D2,FIND("R",SUBSTITUTE(D2,"L","R"),3),LEN(D2))

Yep thank you,
that is neater than mine :D

 

[Peter_SSs]

Yep thank you,
that is neater than mine :D

And István's is neater than mine

In that case I would use:

=REPLACE(D2,1,FIND("R",SUBSTITUTE(D2,"L","R"),3)-1,"")

 

[István Hirsch]

And István's is neater than mine

You are welcome.