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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to check if a certain function is used 2
Delete everything after a certain character? 2
How to search a cell for last instance of repeating character anddelete to end of data 3
How can I use the " character in a string 2
Replace font of one character in a string 3
Macro to test characters with block of cells and change font 4
Remove certain characters from a text string 6
Deleting characters in a column of cells -converting to text strin 2

Back
Top