Wow that is terrific! Can you help me understand your formula so I can recreate it on the actual spread sheet?
=MID(SUBSTITUTE(D11,"*",REPT(" ",10)),FIND(":",SUBSTITUTE(D11,"*",REPT(" ",10)))+3,15)+0
I get the MID function, but not the substitute and repeat functions. I currently get an "#Value!" error.
Bookmarks