View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Need multiple blanks between words

On Tue, 3 Nov 2009 01:52:29 -0800 (PST), skaizun wrote:

I have two words, say, "ALPHA BETA", that are in a merged column(s)
and are text fields and are oriented downward, such that they read as
follows:

A
L
P
H
A
B
E
T
A

The problem is that there is no obvious space between "ALPHA" and
"BETA"; in other words, for some reason, Excel 2003 ignores all spaces/
blanks.

I tried many things, including inserting more than one space between
the words, carriage returns, and even using the HTML " " entity,
but nothing works.

Any help would be appreciated.


How did you enter the data?

Here's what I did:
Merge A1:A13
Enter: ALPHA BETA
Format/Cells/Alignment
Orientation: Select the box that shows Vertical Alignment.

The result showed the space between the two words.
--ron