Position Of Last Occurrence Of Character In String

Gab · Jun 29th 2008

Hi all,

on the web I've found this formula, which returns the postion of the last occurrence of the character in cell B1 in the string in cell A1:

=MAX((MID(A1,ROW(INDIRECT("A1:A"&LEN(A1))),1)=B1)*ROW(INDIRECT("A1:A"&LEN(A1))))

How do I turn this into a VBA function?

AAE · Jun 29th 2008

Re: Position Of The Last Occurrence Of A Character In A String

RichardSchollar · Jun 29th 2008

Re: Position Of The Last Occurrence Of A Character In A String

You don't need a UDF for that as the native InstrRev VBA function does exactly what you want - look it up in the VBA Help.

Richard

Gab · Jun 29th 2008

Re: Position Of The Last Occurrence Of A Character In A String

Thanks a lot!

Dave Hawley · Jun 30th 2008

Re: Position Of Last Occurrence Of Character In String

Custom Function;

Code

Function LastOccurenceOfChar(strVal As String, strChar As String) As Long
    LastOccurenceOfChar = InStrRev(strVal, strChar)
End Function

=LastOccurenceOfChar(A1,"a")

Participate now!