Carriage Return in Microsoft Excel

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).

Digg This
Reddit This
Stumble Now!
Buzz This
Vote on DZone
Share on Facebook
Bookmark this on Delicious
Kick It on DotNetKicks.com
Shout it
Share on LinkedIn
Bookmark this on Technorati
Post on Twitter
Google Buzz (aka. Google Reader)

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>