Show line break in Excel Cell

[Pumba]

Hi there

I am able to generate a line break in an excel cell by using Char(10)
i.e.

A1 A2 A3
Line Break =A1&Char(10)&A2

The above would display in A3 as
Line
Break

which is correct. However there was a symbol (a square I think) which shows where the line break occurs.

How do I generate that and/or display that symbol?

Thanks

P

 

[xenou]

Try this:
Uncheck "Wrap Text" under Cell Formatting.