Theta I+M Excel Blog

Column headings using CHAR(10) function

Written by Simon Jeffery | Jan 27, 2023 4:52:01 PM

Controlling the configuration of Column headings

How to control exactly where the line break goes in the column heading without having to change column widths?

The tip contained in the embedded Spreadsheet explains the use of the Excel concatenation function "&" and the use of CHAR(10) to insert line breaks in to text.

Click on this link to download the spreadsheet:

I+M Excel Tips - CHAR(10)