Formula to return string between chars from right? 1

[JGKWORK]

Hi,

How do I create a formula to return a string from the following (between the last "\"'s)?


\Asbestos\Inspection\001_Dscf0026_2009-09-06.JPG\

I want to return:

001_Dscf0026_2009-09-06.JPG

Many thanks.

 

[JGKWORK]

Sorry meant to say I need this to be a formula in an Excel cell. Thanks.

 

[SkipVought]

Hi,

Simplest way, paste this into a MODULE and use as you would any other spreadsheet function...

Function LastBit(rng As Range) As String
  LastBit = Split(rng.Value, "\")(UBound(Split(rng.Value, "\")) - 1)
End Function

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[JGKWORK]

Really appreciate that but I'm up against it with time and I don't really know VBA or how to impliment it is there any way to do this with a formula?

Many thanks.

 

[SkipVought]

alt+F11 toggles to the VB editor

Insert > Module

Paste

alt+F11 toggles to the sheet

in the cell you need this formula, and assuming that your data is in A1...
[tt]
=LastBit(A1)
[/tt]
Its THAT SIMPLE!


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[JGKWORK]

Superb, worked great and I learned something very useful, many thanks.