How to get rest of characters after last certain character?

  • Thread starter Thread starter Wille
  • Start date Start date
W

Wille

Hi All,


e.g. In cell A1 there is a string = "dummy1\dummy3\cat\test"

In cell B1 I want result = "test"

In pseudo code:

test = functionX("dummy1\dummy3\cat\test"; "\" )

I don't want write visual basic code just use normal excel functions.

Is it possible to write this kind of function?
 
Hi All,


e.g. In cell A1 there is a string = "dummy1\dummy3\cat\test"

In cell B1 I want result = "test"

In pseudo code:

test = functionX("dummy1\dummy3\cat\test"; "\" )

I don't want write visual basic code just use normal excel functions.

Is it possible to write this kind of function?
Click to expand...

=TRIM(RIGHT(SUBSTITUTE(A1,"\",REPT(" ",99)),99))

--ron
 
Back
Top