|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 8th, 2005, 08:13 PM
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
December 8th, 2005, 08:17 PM
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
December 8th, 2005, 08:22 PM
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
December 8th, 2005, 08:29 PM
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
December 8th, 2005, 08:34 PM
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I clear the contents of one cell from another cell? | RonB | Worksheet Functions | 1 | September 26th, 2005 07:33 PM |
| Copy cell format to cell on another worksht and update automatical | kevinm | Worksheet Functions | 21 | May 19th, 2005 11:07 AM |
| Adding contents of one cell to a range of cells. | CLJinVA | Worksheet Functions | 1 | February 10th, 2005 10:19 PM |
| IF E3 & E10 = TRUE set this cell to "Yes", else set to "No" | Timothy L | Worksheet Functions | 5 | August 27th, 2004 02:28 AM |
| getting the contents of a cell using the cell address? | PBAR | Worksheet Functions | 1 | August 20th, 2004 06:57 AM |
Linear Mode
