You posted to the Programming forum, that's why I suppose you are looking for
a VBA function. It's the InstrRev


Regards,
Stefi

€ždelmac€� ezt Ã*rta:

HI all, has anyone got a formula for finding thwe 1st space from the right of
a string
e.g. These can have variable lengths as they are all addresses
Gar 29 Durban Avenue Dalmuir West C

I want to find the space between West and C

Thanks all (again)
--
delmac