Incorporating Carriage Returns into Formulae in Excel Spreadsheets
Following on from yesterday’s tip on how to search for carriage returns in Excel spreadsheets, here’s how you can incorporate this non-printable character into your formulae.
The secret sauce for carriage returns is to include CHAR(10) into your formulae.
For instance, if you want to concatenate two cells but put the values on different lines in the same cell you could do the following:
=A1&CHAR(10)&B1
You may need to enable wrap text on cells containing this formula if the result comes out as one lone string of text though.
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!