| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting characters from a cell
I have the following in cell A2: 4,32,55,10,16
I would like to use formulas to put this in the following cells: B2 = 4 C2 = 32 D2 = 55 E2 = 10 F2 = 16 I have a whole column of these types of entries. the numbers are not always the same length. I can extract the 4 and 16 using Left and Right functions but don't know how to get the remaining 3 numbers. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extracting characters from a cell
Data Text to Columns Delimited Comma Finish
Regards, Ryan--- -- RyGuy "juliejg1" wrote: I have the following in cell A2: 4,32,55,10,16 I would like to use formulas to put this in the following cells: B2 = 4 C2 = 32 D2 = 55 E2 = 10 F2 = 16 I have a whole column of these types of entries. the numbers are not always the same length. I can extract the 4 and 16 using Left and Right functions but don't know how to get the remaining 3 numbers. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extracting characters from a cell
Thank you!!
"ryguy7272" wrote: Data Text to Columns Delimited Comma Finish Regards, Ryan--- -- RyGuy "juliejg1" wrote: I have the following in cell A2: 4,32,55,10,16 I would like to use formulas to put this in the following cells: B2 = 4 C2 = 32 D2 = 55 E2 = 10 F2 = 16 I have a whole column of these types of entries. the numbers are not always the same length. I can extract the 4 and 16 using Left and Right functions but don't know how to get the remaining 3 numbers. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting characters before or after a specific character | Excel Worksheet Functions | |||
| Extracting from a cell | Excel Discussion (Misc queries) | |||
| extracting characters at a specified limit to seperate cells | Excel Discussion (Misc queries) | |||
| Extracting a character from a string of characters | Excel Discussion (Misc queries) | |||
| Extracting last 5 characters from a cell | Excel Discussion (Misc queries) | |||
Linear Mode
