Skip to main content

Posts

Showing posts from October, 2012

How to remove line breaks from Excel cell

Dear Friends,
Today I want to share my experience in Excel.. I think Line Break Character is most popular issue we faced day to day when trying to data cleaning/Transformation in excel or exporting Large data from Excel to SQL for Data warehouse. Sometimes Users typing Enter mistakenly in cell or sometimes copy paste from web page to excel create new line character. 
So before using this excel we need to remove this character to make it proper.
There is quite a few ways to do so, one of them is to useExcel find/replace dialog box.  Using this feature is really straightforward, the only problem is that not everyone knowshow to type in the line break symbol. The trick here is topress ALT and then enter 010 using the numeric keypad.

Happy Reading SumnJha