The solution is to use the INFO function to test the current environment, then adjust the line break character accordingly. We do this by adding this formula to C3: Then we we name C3 “break” so we can use the word break like a variable later. If Excel is running on a Mac, break will equal CHAR(13), if not, break will equal CHAR(10). In column E, we concatenate the address information that appears in B, C, and D with a formula like this: The result of the concatenation is text with line breaks: Traci Brown¬ 1301 Robinson Court¬ Saginaw, MI 48607 Note: make sure you have text wrap enabled on cells that contain line breaks.
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
