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 use Excel find/replace dialog box. Using this feature is
really straightforward, the only problem is that not everyone knows how to type in the line break
symbol. The trick
here is to press ALT and then enter 010 using the numeric keypad.
Happy Reading
SumnJha
This is a wonderful job you are doing sir, seriously hats off to your approach towards life and matured thinking , approach to give something to socity what you have achieved from it, keep it up, god bless you.
ReplyDeleteThank You So much ....
Delete