Thread
:
editing problems in excel
View Single Post
#
2
Nick Hodge
Posts: n/a
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
Reply With Quote