Most people know how to use the search and replace function in Excel spreadsheets but it can be a tricky task if what you’re looking for is a non-printable character like a carriage return (i.e. hitting Enter on the keyboard).<\/p>\n
Thankfully, it’s easy enough to do once you know how \ud83d\ude42<\/p>\n
In the Find and Replace<\/strong> box, click in the\u00a0Find<\/strong> box and do the following:<\/p>\n The box will appear blank but don’t let that put you off – try searching and if your spreadsheet or selected data has carriage returns in it then those results should show up.<\/p>\n If you’re interested in finding tabs, simply replace\u00a00010<\/strong> with 0009<\/strong> when typing on the keypad before kicking off the search.<\/p>\n","protected":false},"excerpt":{"rendered":" Most people know how to use the search and replace function in Excel spreadsheets but it can be a tricky task if what you’re looking for is a non-printable character like a carriage return (i.e. hitting Enter on the keyboard). Thankfully, it’s easy enough to do once you know how \ud83d\ude42 In the Find and … <\/p>\n\n