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/ =-