Prev: syntax to concatenate two named ranges?
Next: Issues - ghost data
From: J on 22 Mar 2010 13:42
How do you create a space between sentences within one cell?
From: Jim Thomlinson on 22 Mar 2010 13:47
Use Alt + <Enter> to add a carriage return to your cell.
--
HTH...

Jim Thomlinson


"J" wrote:

> How do you create a space between sentences within one cell?
From: Dave Peterson on 22 Mar 2010 13:49
Hit the space bar?

If you mean you want to force the next sentence onto a new line within that
cell, hit and hold the alt key when you hit Enter.

If you see a little box where that alt-enter is, then you have to change the
wrap text property.

Rightclick on that cell
Format Cells|Alignment tab|check "Wrap text"




J wrote:
>
> How do you create a space between sentences within one cell?

--

Dave Peterson
From: Roger Govier on 22 Mar 2010 13:57
Hi

Type Alt + Enter to force a line wrap
--
Regards
Roger Govier

J wrote:
> How do you create a space between sentences within one cell?
 | 
Pages: 1
Prev: syntax to concatenate two named ranges?
Next: Issues - ghost data