Return right-most text in a string with multiple delimiters using functions...

[spacely]

Hello,

I am trying to stay out of VBA.

Just want to return the last bit of text..

firstbit\secondbit\lastbit

delimiters will always be \ but could be many. Just need that last bit after the last \.

Thanks in advance!

 

[cerfani]

to find the position of the last '\' you can do this... kinda complicated haha

=Find("@", Substitute(A1, "/", "@", Len(A1) - Len(Substitute(A1, "/", ""))))

i converted it from a udf i used so let me know if it works or not

i need to use / slashes cause mrexcel thinks \ is a control character... the @ character can be any character as long as the character is not in the text to begin with

you are replacing the last \ with a unique character which then you can get the position with Find

 

[markmzz]

Hello,

I am trying to stay out of VBA.

Just want to return the last bit of text..

firstbit\secondbit\lastbit

delimiters will always be \ but could be many. Just need that last bit after the last \.

Thanks in advance!

Try this:

[COLOR=#0000ff]=TRIM(RIGHT(SUBSTITUTE(A1,"\",REPT(" ",99)),99))[/COLOR]

Markmzz

 

[Joyner]

Try This:

=TRIM(RIGHT(SUBSTITUTE(A1,"",REPT(" ",255)),255))

 

[Joyner]

Try This:

=TRIM(RIGHT(SUBSTITUTE(A1,"",REPT(" ",255)),255))

Oops, left out the "", So as above would be:

=TRIM(RIGHT(SUBSTITUTE(A1,"",REPT(" ",255)),255))

 

[markmzz]

Try this:

[COLOR=#0000ff]=TRIM(RIGHT(SUBSTITUTE(A1,"\",REPT(" ",99)),99))[/COLOR]

Markmzz

Oops, left out the "", So as above would be:

=TRIM(RIGHT(SUBSTITUTE(A1,"",REPT(" ",255)),255))

Hi!

Try to use the Code option (#) to post the formula in this case.

Look at my post above.

Markmzz​

 

[Joyner]

Hi!

Try to use the Code option (#) to post the formula in this case.

Look at my post above.

Markmzz​

Thanks Markmzz, I see it is dropping the slash without it.

 

[markmzz]

Thanks Markmzz, I see it is dropping the slash without it.

You're welcome.

Yes, in some case we need to use the Code option.

Markmzz