excel
excel copied to clipboard
justkawal
Line Break
Is it possible to add a line break when adding text to a cell?
I've tried \n and CHAR(10) (obviously a formula) - but nothing works. I can style the the cell with WrapText, but I was hoping it would be possible to concatenate something between strings to allow for more control within the cell.
Current:
I am a dog. I am a cat. I am a Turtle.
Wanting:
I am a dog.
I am a cat.
I am a Turtle.
@jaxnz This can be achieved with the use of list iterates function in excel package
@justkawal Can you explain? I am not talking about different cells, more new lines within the same cell
when open with
Microsoft® Excel for Mac
Version 16.65 (22091101)
License: Microsoft 365 Subscription
Belongs to: [email protected]
Device ID: 34DD76E8-x-x-x-x
© 2022 Microsoft. All rights reserved.
Third Party Notices
Warning: This computer program is protected by copyright law and international treaties. Unauthorized reproduction or distribution of this program, or any portion of it, may result in severe civil and criminal penalties, and will be prosecuted to the maximum
on macOS Sonoma ( 14.x ) its just show on field / column like
HelloThere
but when i open with Google sheets by google, its show
Hello
There
when i check on my Microsoft® Excel for Mac its already have a new line , when i double click on field and release or move cursor to other , its automatic format like on google sheets but not beutyformat , the result is not good like on google sheets that adjustment / following of the length of the text. ( case when the text is long ) .