Need formula help to get text coming after "\" looking from Right side of text.

[pedie]

Hi, I need formula help to get text coming after "\" looking from Right side of text.

C:\Folder1\Folder2\Folder3\mybook.xls
Result = "mybook.xls"

I thinki have started too many threads btu sorry, i need help...cant make this text right find thing work

Thanks agian

 

[AD_Taylor]

Could you use:

=RIGHT(A1,LEN(A1)-FIND(CHAR(1),SUBSTITUTE(A1,"/",CHAR(1),LEN(A1)
-LEN(SUBSTITUTE(A1,"/","")))))

Btw not my formula, found it after a quick Google search for a similar thing.

 

[wigi]

For instance:

[EDIT: too long formula - see other suggestion]

 

[pedie]

Could you use:

=RIGHT(A1,LEN(A1)-FIND(CHAR(1),SUBSTITUTE(A1,"/",CHAR(1),LEN(A1)
-LEN(SUBSTITUTE(A1,"/","")))))

Btw not my formula, found it after a quick Google search for a similar thing.

Thanks for seaching it up for me....
Works perfect! Thanks again!

 

[wigi]

Btw not my formula, found it after a quick Google search for a similar thing.

[edit: not needed anymore]

 

[pedie]

For instance:

=RIGHT(SUBSTITUTE(A1,"\","^",LEN(A1)-LEN(SUBSTITUTE(A1,"\",""))),LEN(SUBSTITUTE(A1,"\","^",LEN(A1)-LEN(SUBSTITUTE(A1,"\",""))))-FIND("^",SUBSTITUTE(A1,"\","^",LEN(A1)-LEN(SUBSTITUTE(A1,"\","")))))

Wigi, works perfect....Thanks for helping out!

 

[Scott Huish]

=trim(right(substitute(a1,"\",rept(" ",255)),255))

 

[pedie]

=trim(right(substitute(a1,"\",rept(" ",255)),255))

HotPepper, Cool, thanks...