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?

Use INSTRREV

string = "dummy1\dummy3\cat\test"
string = mid(string,instrrev(string,"\") + 1)

The instrrev will find the position of the last back slash in the
string. You add one to get everything after the last back slash.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=158814

Microsoft Office Help

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))

--ron

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.