Searching For Carriage Returns and Tabs in Excel Spreadsheets
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 š
In the Find and Replace box, click in theĀ Find box and do the following:
- Hold down theĀ Alt key and typeĀ 0010 on the number pad,
- Let go of the Alt key.
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.
If you’re interested in finding tabs, simply replaceĀ 0010 with 0009 when typing on the keypad before kicking off the search.
Boydo
My name is Boyd and Iām a Service Management Specialist with a knack for operational data gathering, transformation, analysis and reporting.
In 2012, I obtained my Masters of Science in Information Technology through the University of New South Wales @ The Australia Defence Force Academy (UNSW@ADFA).
I was also part of an online community known as the Panasonic Insider Crew in the capacity of āInsider Guruā for Panasonic Australia where I interacted with other tech enthusiasts and find out more about Panasonic's latest gadgets.
I love technology, gadgets, and the Internet and maintain a keen interest in these areas locally, nationally, and globally. I hope by sharing my views on these topics that people will receive an honest point of view from someone with a genuine interest in these topics.
I have also written and edited articles for Neowin - you can check out my articles over @ https://www.neowin.net/news/poster/boyd_chan
I hope you enjoy reading my blog!
Follow Us!