This looks like a relatively simple task but (as already requested by Macropod) we would need to see the original content. If you are reconstructing dummy data to mimic actual but sensitive content then make sure you use exactly the same end of line markers (carriage returns or soft returns) as are in the original content. Also make sure your dummy data contents instances of all variations that might be encountered in real data.

Note that if you explored terms like 'web scraping' you would see that you can automate the entire process of gathering the source directly from the website and doing the data cleansing in a single macro.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia