Extracting characters from a cell

J

juliejg1

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying formulas across columns 2
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Dividing after a long formula 5
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula 2
Avoiding auxiliary cells 0
Same forumula returns both 0 & N/A 2
Multiply with Vlookup value from another Worksheet 0
Formatting a spreadsheet to calculate difference in dates etc. 2

Top