Hey
I have a small problem that i cant seem to find out
i have a text string ex: Apple;House;Wine
I need a formual that returns the last 4 characters after the last ";"
I have tried using find combined with right / left, but cant seem to make it work
Thx in advance
If S is the string and T the return String then try
T = Mid(S,InStrRev(S, ";", -1)+1,4)
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
So if the text was:
hdjsah;6tgf83q;hjkxhvsw;a very small bird
you want the formula to return:
bird
Gary's Student
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks