Need help autosorting information into different cells

  • Thread starter Thread starter Shukumi
  • Start date Start date
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:
 
Use Data, Text to Columns. Move the arrows to line up where you want the data
split to columns
 
You must log in or register to reply here.

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

Need help @_@ 3
Data in sheet1 to be put into sheets 2, 3, 4, 5, etc 2
Using LARGE function in incontiguous cells 4
showing data in a different way based on a spreadsheet excel 07 16
Help with a cashflow table 2
Changing multiple worksheet references in formulae 2
Changing the Status of Cell 1
Moving Hyperlinks 2

Back
Top