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.

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.

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.