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:
Post a Comment