Today, a colleague asked me to help him manipulate a spreadsheet to make it easier and faster for him to turn into an HTML table.

He had a spread sheet consisting of 10 or so columns, one of which housed a list of product codes, separated by semi-colons, in a single cell. What he wanted to do was keep the product codes in a single cell, but instead of having them separated by semi-colons, he wanted them each on their own line.

After some initial head scratching, and a little Googling, I came across the ALT command for a carriage return – Bingo! Once I had this, all that was required was a find replace to replace against the column to replace semi-colon with a carriage return (ALT + 010).