How do you embed a new line in a formula similar to &" "& but with a new line instead
P PMercierPM Oct 27, 2006 #1 How do you embed a new line in a formula similar to &" "& but with a new line instead
E Earl Kiosterud Oct 27, 2006 #2 P, ="Line 1" & CHAR(10) & "Line 2" Have Wrap Text turned on (Format - Cells - Alignment) or you'll get a little square character for the newline.
P, ="Line 1" & CHAR(10) & "Line 2" Have Wrap Text turned on (Format - Cells - Alignment) or you'll get a little square character for the newline.
