Sorting Data Inside of Cell

  • Thread starter Thread starter AFWX
  • Start date Start date
A

AFWX

New to Excel, but have a problem that I need to resolve. I'm pullin
data from a web site (single table) into a spreadsheet. Everything t
this point is perfect. The problem is that I need to sort the dat
within each cell. Example; the number in the cell might read 275510.
need to sort the data into 3 groups, 27,55,10. Does anyone have an
ideas. Again I'm new to Excel but I tend to catch on quick. Thank yo
in advance
 
This will take care of the data as the example that you posted.

If your data starts in A1, enter this in an adjacent column, and drag down
to copy as needed:

=LEFT(A1,2)&","&MID(A1,3,2)&","&RIGHT(A1,2)

If you wish, you can eliminate the formulas and leave just the data behind
in this adjacent column, and perhaps delete the original column.

Select this new column with the revised data, right click in the selection
and choose "Copy".
Right click again, and choose "PasteSpecial", then check "Values", then
<OK>.

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



New to Excel, but have a problem that I need to resolve. I'm pulling
data from a web site (single table) into a spreadsheet. Everything to
this point is perfect. The problem is that I need to sort the data
within each cell. Example; the number in the cell might read 275510. I
need to sort the data into 3 groups, 27,55,10. Does anyone have any
ideas. Again I'm new to Excel but I tend to catch on quick. Thank you
in advance.
 
Back
Top