On 2 joulu, 15:45, Ron Rosenfeld wrote:
On Wed, 2 Dec 2009 05:20:37 -0800 (PST), Wille wrote:
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?

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

Thank you very much. This solved problem.