inserting line break (ent+alt) in a formula

[lezawang]

Hi
I tried this formula ="John"&char(0010)&"Smith"
hoping to get

John
Smith

in the same cell but did not work. Any idea why please? Thank

PS: char(0010) = ctrl+J

 

[KennyGreens]

Why not just type John (alt+enter) Smith?

 

[lezawang]

Want to learn different way to do one thing. Thanks

 

[Special-K99]

Your formula works but you must have Wrap text selected in the cell format or you'll just get "JohnSmith"

 

[Scott Huish]

You don't need the leading zeros there. CHAR(10) will suffice.