Excel help required please

Lifeisbutadream

I have a large Word document which has numbers in - some are tabbed and some spaced - I want to transfer the contents of the document to an excel document with the numbers in cells. Is there an easy way to do this?

Thanks in anticipation!

isofa

They need to all have the same delimiters between the numbers, i.e. all tabs etc, then save this as a text file, and import/open in Excel, and step through what the delimiters are, and it'll import it as best as possible.

Use find and replace in word to get it into a better format first.

nomoneytoday

Copy the numbers, and then paste special in excel (chosing values)

isofa

nomoneytoday wrote: »

Copy the numbers, and then paste special in excel (chosing values)

AFAIK if you try and copy and paste special from Word to Excel, Excel tries to paste as a OLE linked object - it doesn't allow the options as values only (it can drop the data in as text and other options, but you will not retain the delimited data style).

Only if you copy items (values, formula results etc) within Excel and paste special back into another cell/range in Excel do you get those "value only" paste special options...

superjaggybunnet

Put the numbers in MS Word into a table format and then copy that and paste it into MS Excel.

GeorgeUK

Replace the spaces with a tab (special) character. Works best if there is more than just the one sapce between the numbers. Then just copy + paste

Lifeisbutadream

Thanks all - got it sorted..