In the case of concatenating values of different cells, we may need to push a couple of data to the next line. Insert Excel Carriage Return by using Formula It has inserted the carriage return character to push the data to the new line within the same cell. Now again, press the shortcut key ALT + ENTER.Now again, place a cursor in front of the third line data.Now press the excel shortcut key ALT + ENTER to insert the carriage return character in excel cell.Īs you press the ALT + ENTER key, it has pushed the content in front of the selected data to the new line by inserting a carriage return.
First, our data looks like this in a cell. What we need in this case is we need to push the second line to the next line and third line to the next line like the below one. We have three sentences in the cell A1, and each sentence is separated by a comma (,).
