Use Alt-Enter where you want to split the text.

To reverse it, either delete the character from that position, or do
Format | Cells | Alignment and uncheck Wrap text.

Hope this helps.

Pete

japorms wrote:
> Hi Guys,
>
> Does anyone know how to add a new paragraph in a cell?
>
> Example: Book Sale
>
> It needs to look like this:
>
> Book
> Sale
>
> Also, how to reverse it also. Thanks!
>
> I can't find it in Help.
>
>
> --
> japorms
> ------------------------------------------------------------------------
> japorms's Profile: http://www.excelforum.com/member.php...fo&userid=6544
> View this thread: http://www.excelforum.com/showthread...hreadid=572350