Nov 03 2021 01:08 PM
Excel 365 v16.54 on 27 ", late 2015 Mac, running Big Sur 11.6
When I type formula 4 characters ="rr followed by alt+return followed 3 charaters ss" ,
The formula line displays
="rr
ss"
But the value displayed in the cell is
rrss
while typing 'rralt_returnss in the formula line displays properly as the cell value
rr
ss
Is there a way to create a line break within a double quotes forumla?
Nov 03 2021 01:56 PM
SolutionMake sure that you turn on Wrap Text for the cell with the formula.
Nov 04 2021 01:06 PM
Nov 03 2021 01:56 PM
SolutionMake sure that you turn on Wrap Text for the cell with the formula.