Hy,
I have a text looks like:
"abcdef | 123456 | xyz"
I need to show only the last few character after the last " | " character, (delete everything before the last " | " and the pipe character too)
so in this case i need: "xyz" (the number of the characters is different all the time)
Oh, and i need to do this with VBA, not with formula.
Thanks for your help!
I have a text looks like:
"abcdef | 123456 | xyz"
I need to show only the last few character after the last " | " character, (delete everything before the last " | " and the pipe character too)
so in this case i need: "xyz" (the number of the characters is different all the time)
Oh, and i need to do this with VBA, not with formula.
Thanks for your help!

Last edited: