Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Splitting the contents of a cell?
Hi,
I have several columns of data that contain data such as:3001001E:Name I want to keep what is on the right side of the colon. How could I do this with a function? Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Splitting the contents of a cell?
Dan,
try the following formula, which assumes that your text is in A1. MID(A1, FIND(":", A1)+1, LEN(A1) HTH Kostis Vezerides |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Splitting the contents of a cell?
For 3001001E:Name in Cell A1
B1: =RIGHT(A1,LEN(A1)-(SEARCH(":",A1))) Does that help? *********** Regards, Ron "Dan B" wrote: Hi, I have several columns of data that contain data such as:3001001E:Name I want to keep what is on the right side of the colon. How could I do this with a function? Thanks. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Splitting the contents of a cell?
That worked perfectly. I would like to understand the logic behind that
function. If you get a minute, could you give me a quick explanation. Thank you so much!! "vezerid" wrote in message oups.com... Dan, try the following formula, which assumes that your text is in A1. MID(A1, FIND(":", A1)+1, LEN(A1) HTH Kostis Vezerides |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Splitting the contents of a cell?
that one worked too. I wish I understood how. Very cool though.
Thanks!! "Ron Coderre" wrote in message ... For 3001001E:Name in Cell A1 B1: =RIGHT(A1,LEN(A1)-(SEARCH(":",A1))) Does that help? *********** Regards, Ron "Dan B" wrote: Hi, I have several columns of data that contain data such as:3001001E:Name I want to keep what is on the right side of the colon. How could I do this with a function? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
separating numbers and letters from alphanumeric cell contents | Excel Worksheet Functions | |||
Cell contents as the 'lookup value' parameter in HLOOKUP function | Excel Discussion (Misc queries) | |||
Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
How do I find the contents of a cell using the "ADDRESS" function. | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |