Find data to the Right of...

  • Thread starter Thread starter Mike R.
  • Start date Start date
M

Mike R.

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
 
try

=MID(SUBSTITUTE(A1,":","^",LEN(A1)-LEN(SUBSTITUTE(A1,":",""))),FIND("^",SUBSTITUTE(A1,":","^",LEN(A1)-LEN(SUBSTITUTE(A1,":",""))))+1,256)

Mike
 
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
Click to expand...


=TRIM(RIGHT(SUBSTITUTE(TRIM(A1),":",REPT(" ",99)),99))

If the string you are returning might be longer than 99 characters, increase
that value appropriately in both sections. e.g:

=TRIM(RIGHT(SUBSTITUTE(TRIM(A1),":",REPT(" ",1024)),1024))

--ron
 
Back
Top