Advanced search

Can I somehow import data from a word document into a excel spreadsheet

(8 Posts)
MmeGoblindt Wed 14-Oct-09 17:22:01

without cut and pasting every line?

I have a word doc with a list of names and email addresses and would like to have a spreadsheet so that I can add addresses, telephone numbers etc, and so that I can alphabetisise the list.

Can this be done?

ib Wed 14-Oct-09 17:24:07

Yes, you should be able to, copy and paste, then go to 'text to columns' and choose what it is that gives the new cell. What version of exel are you on?

MmeGoblindt Wed 14-Oct-09 17:25:09

Excel 2007

StealthPolarBear Wed 14-Oct-09 17:25:25

ib means delimiter, probably space will do although it may also separate the names, but you'll be able to sort that out

StealthPolarBear Wed 14-Oct-09 17:26:07

you can send it to me if you like and ill do it (or are they confidential??)
Kate Fallon 44 at hot mail dot com

MmeGoblindt Wed 14-Oct-09 17:27:36

Oh, would you SPB. That is so fab of you. They are not confidential no.

Will email you.

StealthPolarBear Wed 14-Oct-09 17:28:44

no problem will watch for mail

StealthPolarBear Wed 14-Oct-09 18:36:33

sent back, sorry it's taken so ;long!

Join the discussion

Registering is free, easy, and means you can join in the discussion, watch threads, get discounts, win prizes and lots more.

Register now »

Already registered? Log in with: