How to keep the new format of web imported data after refresh?

[Whitesnake]

Hi all,
I am creating an Excel database. I would like to import names, emails and job positions of all employees of a firm from the firm website.
I chose Data->From Web and selected the whole page, as only one yellow icon to select data was available.

I imported the data into my Excel spreadsheet and I began to change their format, by moving email accounts in the "email" column and similarly for job positions and names.

I would like to refresh data keeping this new format. Unfortunately, every time I refresh the imported data using the "refresh all" button, they return to the original format, which is quite bad.

I thank you all for your support!

Kr,
W

[Special-K]

Duplicate post

http://www.excelforum.com/excel-new-...72#post3143672

[Whitesnake]

Hi Special-K,
you are right: should I keep my post in "Excel General" or in "Excel -New Users/Basics"?

Regards
W