Refreshing data import issue

Hi

I need to import data from a web page on a fairly often basis.

The format it scrapes from the web page onto excel i need to change and add formulae.

Is there anyway that each time it refreshses the data it will go into the format i have changed the first scrape to and keep the forumale i have entered?

For instance part of the data is a numeric string: 5|4|5|5 which goes into 1 cell. I need to separate the 4 numbers out into 4 cells instead of 1.

Thanks

Nick

For instance part of the data is a numeric string: 5|4|5|5 which goes into 1 cell. I need to separate the 4 numbers out into 4 cells instead of 1.

For this part you can use the Data - Text to columns menu