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.
|