Sorting Problem

  • Thread starter Thread starter grrrdrbr
  • Start date Start date
G

grrrdrbr

Hello, I'm a teacher looking for a way to sort or filter data within
cell. I'm importing data into a single table (no other options) fro
the web. The data comes in like this 275521. Is there any way that
can set up the spreadsheet to split up the data into 27, 55, 2
separately? Thanks for any help or advise
 
When you say, "split the data", do you mean *within* the individual cell,
OR, do you mean into separate cells across the columns.

The second choice is the easiest and fastest using <Data> <Text To Columns>,
and choosing "fixed width", where you can move the separators around any
which way you prefer.

The first choice can be accomplished using a text formula in a "helper"
column, which breaks up the data. You can then copy this "helper" column
to *itself*, and eliminate the formulas, leaving just the separated data
behind.

For example, with data in A1, enter this in B1:

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

Copy down as needed.
Now, select the data in column B, and right click in the selection, and
choose
<Copy>
Right click again, and choose
<PasteSpecial>
Click in "Values", then <OK>.

You now have just the data remaining in column B.
--

HTH,

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


Hello, I'm a teacher looking for a way to sort or filter data within a
cell. I'm importing data into a single table (no other options) from
the web. The data comes in like this 275521. Is there any way that I
can set up the spreadsheet to split up the data into 27, 55, 21
separately? Thanks for any help or advise.
 
Grrrdrbr,

If the data are all two digits, you could select the cells
and use the "Text to Columns" Function under the Data
menu. Select "Fixed Width", "Next", then move the
vertical lines to where you want them.

Hope this helps!

Eric
 
Another way.........

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

Vaya con Dios,
Chuck, CABGx3
 
From the "Data" menu select "Text to Columns" then
Select "Fixed Width" style on Page 1 of the Wizard and
follow the instructions on Page 2. Then select "Finish"
and you should have the desired result .....
 
Back
Top