Excel Importing Data

  Durko 12:52 25 Oct 2006
Locked

Is it possible to import rows of data like below from the internet and transfer to an Excel workbook and retain the format?.

I'm not sure but I think it can be done using MS Word as the original source setting out data with commas or something then saving it as a plain text file with inserted tabs, commas or spaces. I'm working from the above scenario though.

Advice much appreciated.


Barnardos 6, Bank Street, Braintree, CM7 1UL

Cancer Research Campaign 31, Bank Street, Braintree, CM7 1UG

Children's Society 12, New Street, Braintree, CM7 7ES


Durko

  VoG II 12:56 25 Oct 2006

You can just paste it directly into Excel. It will go into one column, in successive rows.

If you want it split across columns like

Barnardos ¦ 6 Bank Street ¦ Braintree ¦ CM7 1UL

select all of the rows, Data > Text to columns, and use , as the delimiter.

  Durko 13:00 25 Oct 2006

Vog

Thanks for the advice works a treat.

Durko

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

How secure is your Wi-Fi?

AMD vs Intel: we put the most powerful desktops for designers and artists head-to-head

iPhone tips & tricks

Les meilleurs ordinateurs portables 2017