| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find data to the Right of...
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find data to the Right of...
On Mon, 18 Aug 2008 09:05:01 -0700, 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 =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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find, Match data and paste data between two workbooks | Excel Discussion (Misc queries) | |||
| Find formatting doesn't work: "Excel cannot find data" | Excel Discussion (Misc queries) | |||
| Despite data existing in Excel 2002 spreadsheet Find doesn't find | Excel Discussion (Misc queries) | |||
| The match and lookup functions can find literal data but not the same data referenced from a cell | Excel Discussion (Misc queries) | |||
| FIND DATA WITHIN DATA (V-OR-H LOOKUP/FIND/MATCH?) | Excel Worksheet Functions | |||
Linear Mode
