Create automated excel sheet which adds "http://www." & "http://" to entries

[ruifct]

Hi guys,

Can I please request your help creating a macro/solution for the following situation:

- Column A: list of urls -> for example: website1, website 2, website 3, ...
- Column B: ="http://www."&A1 -> http://www.website1.com http://www.website2.com http://www.website3.com
- Column C: ="http://"&A1 -> http://website1.com http://website2.com http://website3.com
- Column D: should display the entries on column B + the entries on column C -> http://www.website1.com http://www.website2.com http://www.website3.com http://website1.com http://website2.com http://website3.com

The final goal is to be able to paste a list of urls on column A and automatically get the results on column D. If possible, there's no need to display the data on currently being shown on columns B and C, only the outcome on column D.

Any help will be greatly appreciated!

 

[ruifct]

On column A i meant website1.com website2.com website3.com