Replace newline break in Excel

0 min read 39 words

Ever needed to find & replace the newline character in a large excel document?

In the Replace Dialog (Ctrl+F)
Find: Hold down [alt] and type 010 on the numeric keypad.
Replace: Replace with a space " " (without quotes)

Andrew
Andrew

Andrew is a visionary software engineer and DevOps expert with a proven track record of delivering cutting-edge solutions that drive innovation at Ataiva.com. As a leader on numerous high-profile projects, Andrew brings his exceptional technical expertise and collaborative leadership skills to the table, fostering a culture of agility and excellence within the team. With a passion for architecting scalable systems, automating workflows, and empowering teams, Andrew is a sought-after authority in the field of software development and DevOps.

Tags