A formula could work, but since I'm starting with a CSV file I was
thinking that a macro would be easier for the people who would use it
(unfortunatly not the brightest people I have come across).

Of course my thinking could be wrong.

What would the formula be? Maybe with that I can come up with a good
way of doing it, copy and paste maybe.