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 use . Using this feature is really straightforward, the only problem is that not everyone knows . The trick here is to .