i'd like to create a line break in a formula, but char 13 doesn't work
Id like to create a line break in a formula, but char 13 doesn’t work. The minimum argument has to be 32. Any ideas?
Mac mini, macOS 12.6
Id like to create a line break in a formula, but char 13 doesn’t work. The minimum argument has to be 32. Any ideas?
Mac mini, macOS 12.6
I've never understood that limitation in the function, other than for compatibility with Excel. You can use 8232 instead. It is a unicode line separator character.
I've never understood that limitation in the function, other than for compatibility with Excel. You can use 8232 instead. It is a unicode line separator character.
Try option-return, as Ive done here between 15 and *2000.
(Numbers automatically replaces the multiplication operator ( * ) with the multiplication sign (×).
Regards,
Barry
Option Return works. If in a formula it needs to be in quotes.
Thanks, that worked.
thanks, but that didn't work. I was trying to concatenate mailing addresses
i'd like to create a line break in a formula, but char 13 doesn't work