31 October 2013

Search and Replace new lines in Excel

To search and replace newlines in Excel I just found out that you don't use "\n\r" like in all other Tools I know but instead just press STRG + J. Than the cursor changes a little an it will find new lines in cells. Thank you Microsoft for hiding this feature :)

No comments: