How to make a space
 

Hello folks. I have forgotten how to make a space. in Excel. It is ALT
+???

EXAMPLE :

relationship
is one of a qualifying child
and not a qualifying relative


I WANT IT TO READ:

relationship

is one of a qualifying child
and not a qualifying relative

NOTICE THE SPACE BETWEEN RELATIONSHIP & "IS ONE OF A
QUALIFYING
CHILD ETC

Is it ALT??? THANKS Robin

How to make a space
 

Called text wrap
Done with ALT+ENTER
Sometimes you need to format the cell to put text wrap on
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"audit2" wrote in message
ups.com...
Hello folks. I have forgotten how to make a space. in Excel. It is ALT
+???

EXAMPLE :

relationship
is one of a qualifying child
and not a qualifying relative


I WANT IT TO READ:

relationship

is one of a qualifying child
and not a qualifying relative

NOTICE THE SPACE BETWEEN RELATIONSHIP & "IS ONE OF A
QUALIFYING
CHILD ETC

Is it ALT??? THANKS Robin

How to make a space
 

Use ALT ENTER

You might have to format to wrap text.

--
Biff
Microsoft Excel MVP


"audit2" wrote in message
ups.com...
Hello folks. I have forgotten how to make a space. in Excel. It is ALT
+???

EXAMPLE :

relationship
is one of a qualifying child
and not a qualifying relative


I WANT IT TO READ:

relationship

is one of a qualifying child
and not a qualifying relative

NOTICE THE SPACE BETWEEN RELATIONSHIP & "IS ONE OF A
QUALIFYING
CHILD ETC

Is it ALT??? THANKS Robin