SEARCH - but from Right to Left...

[Aitch]

I have data in a column which looks something like this:

1X3456789 - SEARCH ("X" , A1) = 2
234X73876 - SEARCH ("X" , A2) = 4
839030X38 - SEARCH ("X" , A3) = 7

Is there a way to SEARCH in reverse so it looks from Right to Left ??

1X3456789 - reverseSEARCH ("X" , A1) = 8
234X73876 - reverseSEARCH ("X" , A2) = 6
839030X38 - reverseSEARCH ("X" , A3) = 3


Thank you for any help!

 

[jon1315]

Afternoon
Could you just do the len - the normal search?

 

[jon1315]

so assume your first one is in cell a1, do =len(a1)-search("x",a1)

 

[arthurbr]

Perhaps Len (A1)-SEARCH ("X" , A1)+1

 

[Fluff]

How about
=LEN(A1)- SEARCH ("X" , A1)+1

 

[Trevor G]

Try =LEN(A1)-FIND("X",A1)

 

[Aitch]

Awesome, thanks guys!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Aitch]

Sorry for bothering everyone once more!

If the cell has 2 or more X - it gives the first instance from the Left... how can I still get the first instance from the Right?

1X3456X89 - LEN(A1) - SEARCH ("X" , A1) +1 = 2 but needs to be 3
234XX3876 - LEN(A2) - SEARCH ("X" , A2) +1 = 4 but needs to be 5
23X76X35X - LEN(A3) - SEARCH ("X" , A3) +1 = 3 but needs to be 1


Also, this is the formula I'm using to leave the result empty if there is no X - but is there a better/cleaner way?

=IF (IFERROR (SEARCH ("P" , A1) , "") = "" , "" , LEN(A1) - SEARCH ("P" , A1) +1)


Thanks again!

 

[Fluff]

How about

+Fluff New.xlsm
	A	B
1
2	1X3456X89	3
3	234XX3876	5
4	23X76X35X	1
Master

Cell Formulas
Range	Formula
B2:B4	B2	=LEN(A2)-SEARCH("|",SUBSTITUTE(A2,"X","|",LEN(A2)-LEN(SUBSTITUTE(A2,"X",""))))+1