 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
used to be able to do this but now I cant? MS word 2010.
I have a very large table, one column wide, example
2
4
3
1
and want to select the table then 'convert table to text' and end up with a long list of numbers separated by [comma] so I get
2,4,4,1 etc
for some reason now it wont work. I just get text with each number on a new line so it looks like a table (but without cells)
It's driving me nuts - Help!
C
find and replace the paragraph break with a comma:
Find: ^p
Replace: ,
Find and replace with special characters and wildcards is the nuts for sorting out other people's badly formatted cack.
Fantastic, thanks! I didn't know that ^p could be used as a paragraph mark.
my list proudly posted below!
thanks
5.6,, 1.2, 5.4, 1.2, 4.4, 1.2, 3.0, 1.2, 4.7, 0.4, 1.2, 3.0, 1.2, 0.8, 1.2, 8.2, 4.0, 1.2, 3.0, 1.2, 8.0, 0.4, 0.8, 1.2, 3.0, 1.2, 4.4, 1.8, 4.6, 1.2, 1.2, 1.2, 3.0, 1.2, 1.2, 5.2, 1.2, 8.6, 1.2, 3.0, 1.2, 0.8, 8.6, 1.8, 3.5, 1.6, 0.8, 1.2, 3.0, 1.2, 0.8, 1.4, 3.3, 1.4, 0.8, 1.2, 3.0, 1.2, 5.4, 1.8, 7.2, 7.2, 3.0, 0.8, 1.2, 1.2, 5.0, 2.8, 4.0, 1.2, 3.0, 1.2, 4.2, 2.0, 0.8, 1.2, 3.0, 1.2, 1.2, 5.2, 12.6, 1.2, 5.1, 1.5, 1.2, 3.0, 1.2, 1.5, 1.5, 5.2, 1.8, 0.8, 1.2, 3.0, 1.2, 0.8, 1.2, 3.0, 1.2, 0.8, 1.2, 3.0, 1.2, 5.4, 1.8, 7.4, 7.0, 1.5, 0.8, 1.2, 3.0, 1.2, 5.0, 1.2, 3.0, 1.2, 0.8, 1.6, 3.3, 1.4, 0.8, 1.4, 3.0, 1.4, 0.8, 1.4, 4.5, 7.2, 1.8, 0.8, 1.2, 3.0, 1.2, 0.8, 2.0, 3.8, 1.2, 3.0, 1.2, 4.4, 2.0, 0.8, 1.2, 3.0, 1.2, 4.8, 0.8, 1.2, 3.0, 1.2, 8.4, 1.2, 5.1, 1.2, 1.2, 3.0, 1.2, 1.2, 1.2, 5.4, 1.2, 0.8, 1.2, 3.0, 1.2, 6.4, 1.2, 3.0, 1.2, 3.0, 1.2, 3.0, 1.2, 3.8, 1.0, 1.2, 1.2, 3.0, 1.2, 5.0, 2.0, 3.1, 4.0, 7.1, 0.6, 7.2, 4.0, 6.4, 1.1, 2.0, 7.0, 8.2, 6.8, 4.0, 19.8, 1.2, 4.8, 0.6, 3.0, 7.2, 1.2, 0.8, 3.0, 0.8, 1.0, 1.2, 3.4, 1.1, 4.8, 1.2, 3.0, 1.2, 0.8, 1.2, 7.2, 10.2, 1.0, 0.8, 1.2, 3.0, 1.2, 4.8, 1.2, 3.0, 1.2, 8.2, 0.8, 0.8, 1.2, 3.0, 1.2, 4.8, 12.6, 1.1, 5.2,
Yes, as above. The "Convert to Text" retains the carriage returns so you have to replace them with commas.
Wouldn't it be easier to read in a table? Oh and you have two commas after the first number.