If you want to extract what's to the right of the last forward slash you can
use

=RIGHT(A1,LEN(A1)-FIND("^^",SUBSTITUTE(A1,"/","^^",LEN(A1)-LEN(SUBSTITUTE(A1,"/","")))))

if you want the position

=FIND("^^",SUBSTITUTE(A1,"/","^^",LEN(A1)-LEN(SUBSTITUTE(A1,"/",""))))


Regards,

Peo Sjoblom

"Francis Hayes (The Excel Addict)" wrote:

I'm sure I've done this in the past but for the life of me I can't remember
it now.

Say I have a string "http://www.theexceladdict.com/tutorials.htm" in cell
A1. I want to determine the position of the last "/" (forward slash). The
strings won't always contain the same # of "/"s.

I need to be able to do this as a formula and also in VBA code.

I appreciate your help.

--
Have a great day,
Francis Hayes (The Excel Addict)

http://www.TheExcelAddict.com
Helping Average Spreadsheet Users
Become Local Spreadsheet Experts