Home |
Search |
Today's Posts |
#1
|
|||
|
|||
editing problems in excel
I have a series of numbers edited in word as a single word ex: 0101111100111,
what can I do in order to insert each number (0, 1, 0, 1, 1, ....) in a single cell when copying to excel. I have a large amount of data so inserting tabs manually in word between each number is impossible |
#2
|
|||
|
|||
Marie-Jose
Highlight the data and select Datatext to columns. Take the 'fixed width' option and enter a break every character in the next stage of the wizard -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Marie-Jose" wrote in message ... I have a series of numbers edited in word as a single word ex: 0101111100111, what can I do in order to insert each number (0, 1, 0, 1, 1, ....) in a single cell when copying to excel. I have a large amount of data so inserting tabs manually in word between each number is impossible |
#3
|
|||
|
|||
One idea: in Word, do a search-and-replace and replace each "0" with
"0,"; then replace each "1" with "1,". Import to Excel and perform a text to columns using the comma as the delimiter. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel Page Range Printing Problems | Excel Discussion (Misc queries) | |||
problems with printing format for excel table in Publisher 2003 | Excel Discussion (Misc queries) | |||
Problems with Excel Horizontal arrays with regional options using. | Excel Discussion (Misc queries) | |||
Problems pasting images into Excel | Excel Discussion (Misc queries) |