Need help @_@

S

Shukumi

So I have about 911 things to input into Microsoft Excel, and they are
supposed to be seperated by 4 different categories. I tried copying and
pasting everything, hoping everything would be autoformated into
seperate cells, but everything just got inputted into the whole first
column and only the first cell.

So the first cell basically looked like:
Category 1 Category 2 Category 2 | Cell 2
Info for Cat1 Info for Cat2 Info.etc| Cell 2

What I'm hoping for it to look like when I paste everything in is:
Category 1 | Category 2 | Cateogory 3
Info Info | Info info | Info Info

Help?:confused:
 
G

Gord Dibben

You're confused?

How about the rest of us?

From where did you get the 911 things?

In what format?

Why should Excel have any idea what a Category is and where to place it?

Give us a small example of your data from wherever it comes and the format it is
in.


Gord Dibben MS Excel MVP
 
K

Ken Wright

If your dat ais all fixed width then use Data / Text To Columns with Fixed
Width, or if not then maybe you can use it with deleimited and choose space
as the delimiter. Depends on the data really and hard to say without seeing
an example.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 
Top