Excel Importing Data

  Durko 12:52 25 Oct 06

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


  VoG II 12:56 25 Oct 06

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 06


Thanks for the advice works a treat.


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

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac