How to Line Break in Excel Using Ampersand (&) sign
Ampersand sign is a concatenation operator. It is used in between the text to be joined. CHAR(10) in between the formula can be used to enter a line break.
Syntax: text1 & CHAR(10) & text2 & CHAR(10) & text3…
Example:
Output:
How to Concatenate with a Line Break in Excel?
Excel is a powerful tool to store, manage, and visualize large amounts of data. This tool is usually used by accounting professionals for the analysis of financial data but can be used by anyone to manage large data. Data is entered into the rows and columns. And then, various formulas and functions can be used to get insights from the data.
Contact Us