Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to copy data in one cell into different rows
I have an extra ordinary problem. I scanned some data sheets from
census into excel and the datas have come in one single cell instead of different rows of numbers. I would liek to know if there is possibility to rearrange into different rows... In order to get a visual... The data should be 112 345 223 455 (in consecutive cells) but its 112 345 223 455 in same cell. Any sugesstions as i have 25 sheets of data??? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to copy data in one cell into different rows
catchxen, have a look at data, text to columns, if you need more help with
it post back -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "catchxan" wrote in message oups.com... I have an extra ordinary problem. I scanned some data sheets from census into excel and the datas have come in one single cell instead of different rows of numbers. I would liek to know if there is possibility to rearrange into different rows... In order to get a visual... The data should be 112 345 223 455 (in consecutive cells) but its 112 345 223 455 in same cell. Any sugesstions as i have 25 sheets of data??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Copy the value of a cell to any given cell | Excel Discussion (Misc queries) | |||
hpw do I logic test a cell then copy the row to diff. SS | Excel Worksheet Functions | |||
Merge cell & Copy Data from different cell | Excel Discussion (Misc queries) | |||
How do I copy data from a cell in one file to another? | New Users to Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |