lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Thank you for your help, I understand the break lines now are char(10) and ctrl-J
So if i have in one cell the following
[TABLE="class: outer_border, width: 300"]
<tbody>[TR]
[TD]John Smith
123 Main street
Mycity, 123445555[/TD]
[/TR]
</tbody>[/TABLE]
So if I want name and address and city in different columns then I use text-2-columns and the delimiter is CTRL-J. Or use
substitute(A1, char(10), " ")
My question, where to find or how do you know CTRL-J is break line? is there anytime to refer to? thank you much
Ps: can not change the title sorry, i meant char (10)
So if i have in one cell the following
[TABLE="class: outer_border, width: 300"]
<tbody>[TR]
[TD]John Smith
123 Main street
Mycity, 123445555[/TD]
[/TR]
</tbody>[/TABLE]
So if I want name and address and city in different columns then I use text-2-columns and the delimiter is CTRL-J. Or use
substitute(A1, char(10), " ")
My question, where to find or how do you know CTRL-J is break line? is there anytime to refer to? thank you much
Ps: can not change the title sorry, i meant char (10)
Last edited: