I’ve always wanted to insert a carriage return break within a cell in an Excel spreadsheet. Before, I used to fill it up with spaces (wearing out my space bar!) until the cursor appears on the first character space of the next line.

I don’t have to do that anymore…WOOHOO! Searched the web for answers and found this….

Type this within the cell:

=”[text]” & CHAR(10) & “[text]“

or, if you would like to merge the data in 2 text fields:

= A1 & CHAR(10) & B1

It may seem a pain when it comes to editing it, but it works…I got my carriage returns within the cell!

Like

Unlike