Need help autosorting information into different cells


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:


--
Shukumi
------------------------------------------------------------------------
Shukumi's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36923
View this thread: http://www.excelforum.com/showthread.php?threadid=566325

.

Relevant Pages

  • Excel shifts to wrong worksheet automatically
    ... If it is only data that you are copying and pasting, ... could just link the first cell of the top left location ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Need help autosorting information into different cells
    ... Move the arrows to line up where you want the data ... Shukumi wrote: ... seperate cells, but everything just got inputted into the whole first ... So the first cell basically looked like: ...
    (microsoft.public.excel.misc)
  • Need help @_@
    ... I tried copying and ... pasting everything, hoping everything would be autoformated into ... seperate cells, but everything just got inputted into the whole first ... So the first cell basically looked like: ...
    (microsoft.public.excel)
  • Re: how do i copy and inserted drawing object in a cell to multiple ce
    ... When you copy it you are copying only the one object. ... When you select multiple cells and paste, you are pasting the one object only. ... it only copies to the first cell that i selected ...
    (microsoft.public.excel.misc)
  • Re: VBA word Table Page
    ... Its staying in the second page but its pasting the 3rd, ... > 4th pages first cell contents in second page first cell. ... This reply is posted in the Newsgroup; please post any follow question or reply ...
    (microsoft.public.word.vba.customization)
Loading