Find last character within text (search right to left)

[Midsy]

Hello,

I would like to search from right to left within a cell to find the "last" position of a character. The character might appear any number of time, hence find() is not good because I can't be sure how many times it will appear.

Eg Find the position of "." if the following text were in a cell:

Hello. I'm Peter. Welcome.

How do I find the position of the third "."?

 

[Peter_SSs]

Midsy

Welcome to the MrExcel board!

This will give an error if there is no "." in the cell, but see if it is any help. The "@" needs to be some character that will not occur in your cells.

Excel Workbook
	A	B
1	Hello. I'm Peter. Welcome.	26
2	Hello. Goodbye	6
Last Pos

 

[Midsy]

Peter,

Thank you very much. I can cover the error problem with iserror().

Funny, I thought there would be a function for searching in the reverse order, it just seems so needed.

Love ya work.

Mids

 

[Peter_SSs]

Peter,

Thank you very much. I can cover the error problem with iserror().

Or maybe:
=IF(ISNUMBER(FIND(".",A1)),FIND("@",SUBSTITUTE(A1,".","@",LEN(A1)-LEN(SUBSTITUTE(A1,".","")))),"")

 

[Midsy]

Cheers again Peter,

You have improved on my function - which was:
=IF(ISERROR(FIND("@",SUBSTITUTE(A1,".","@",LEN(A1)-LEN(SUBSTITUTE(A1,".",""))))),"Not Code",FIND("@",SUBSTITUTE(A1,".","@",LEN(A1)-LEN(SUBSTITUTE(A1,".","")))))

You have earned your surf today!