break lines - char(1), ctrl-J

[lezawang]

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

John Smith 123 Main street Mycity, 123445555

<tbody>
</tbody>

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)

 

[MARK858]

https://contexturesblog.com/archives/2013/05/28/find-and-replace-line-breaks-in-excel/