Find data to the Right of...
try
=MID(SUBSTITUTE(A1,":","^",LEN(A1)-LEN(SUBSTITUTE(A1,":",""))),FIND("^",SUBSTITUTE(A1 ,":","^",LEN(A1)-LEN(SUBSTITUTE(A1,":",""))))+1,256)
Mike
"Mike R." wrote:
Hi -
I have a cell with data in which I am trying to pull the data from the right
of a colon. The challenge I am facing is the data may have more than one
colon. I only want the data to the right of the last colon.
help.
Mike
|