substring out of a string

[MaartenRo]

Hi,

I would like a macro that shows the substring between the last "\" and the first space in a string. How do i do this?
e.g. the string "aaaaaaa\bbbbb\cccc\dddddd ggg ffff" should display "dddddd" in the column next to it.

Any input is much appreciated!

[Phuocam]

Try this

Please Login or Register  to view this content.

[Bo_Ry]

Please try
Formula
=TRIM(LEFT(SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(A2,"\",REPT(" ",90)),90))," ",REPT(" ",90)),90))

UDF =lsl(a2)

Please Login or Register  to view this content.

or Sub

Please Login or Register  to view this content.

[MaartenRo]

Thanks, works perfect

[mohadin]

Hi
Macro?

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.