Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? -- Shukumi ------------------------------------------------------------------------ Shukumi's Profile: http://www.excelforum.com/member.php...o&userid=36923 View this thread: http://www.excelforum.com/showthread...hreadid=566325 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help autosorting information into different cells
Use Data, Text to Columns. Move the arrows to line up where you want the data
split to columns Shukumi wrote: 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? -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to add values of cells only if a corresponding cell has information on it | Excel Discussion (Misc queries) | |||
a function that counts the number of cells with information | Excel Worksheet Functions | |||
a function that counts the amount of cells with information in them | Excel Discussion (Misc queries) | |||
Copy information from one cell to several different cells | Excel Discussion (Misc queries) | |||
filling information in cells | Excel Discussion (Misc queries) |