If cell B17 contains your sentence
put the following formula into any other cell
=RIGHT(B17,LEN(B17)-FIND("**",B17)-2)
The RIGHT function extracts the right-most characters from a string of text (your sentence in a cell) for a set number of characters.
The LEN functions calculates how long the text string is
The FIND function finds the specified characters (**) in a string of text (your sentence in a cell) and returns the starting character. Combine all of these functions, as above, then take a further two (that represents the length of the two asterisks) off the length to extract. e.g
FIND("**",B17) would equal 13
minus 2 equals 11
LEN(B17) would equal 40
minus the 11 from the FIND function equals 29
therefore, the RIGHT function would extract the right-most 29 characters from the string of text that is your sentence to give the answer you are seeking.
Hope it helps and isn't too confusing?
Regards
G
--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://www.shemes.com/ =-
Bookmarks