I am using MS Excel on a Mac.
I have a formula.
Guests!A1 & " " & Guests!B1 & I WANNA PUT NEWLINE HERE Guests!C1
... How do you do this????
Thx!
A:
Does Option+Return work on the Mac version like Alt+Enter would do in the Windows version?
Coxy
2009-11-04 06:44:47
+3
A:
CHAR() is the appropriate function for an Excel formula, and you need character 10 (Line Feed) to create a line break. Example:
Guests!A1 & " " & Guests!B1 & CHAR(10) & Guests!C1
You'll need to have word-wrapping enabled on the cell, otherwise CHAR(10) will just look like a little square.
vbCRLF would be the right choice when using VBA (i.e., a macro). The question is about formulas, not VBA. Office for Mac doesn't even support VBA.
richardtallent
2009-11-04 06:46:27
A:
=Guests!A1 & " " & Guests!B1 & "<press Alt+Enter>
" & Guests!C1
Replace <press Alt+Enter> by the actual key combination.
On a Mac, as Coxymla suggested, you will maybe replace Alt with another key ?
iDevlop
2009-11-04 06:55:42
That trick only works for straight text. If you have a formula it does add a separate line in the formula bar, but that will not translate to the cell formatting. richardtallent's suggesting of char(10) is the way to go.
guitarthrower
2009-11-04 16:42:48