Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / October 2006

Tip: Looking for answers? Try searching our database.

CHAR(10) = ALT+ENTER??

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Epinn - 28 Oct 2006 21:32 GMT
A1:  The Olympics
B1:   2008
C1:  =A1&CHAR(10)&B1

I expect the result in C1 to be

The Olympics
2008

But, I have

The Olympics 2008

I don't get the ALT+ENTER effect using CHAR(10) for line feed.

What have I missed?  Thanks.

Epinn
Gary''s Student - 28 Oct 2006 21:51 GMT
Format the cell with wrap on
Signature

Gary's Student

> A1:  The Olympics
> B1:   2008
[quoted text clipped - 14 lines]
>
> Epinn
Roger Govier - 28 Oct 2006 21:51 GMT
Format>Cells>Alignment>Wrap Text

Signature

Regards

Roger Govier

A1:  The Olympics
B1:   2008
C1:  =A1&CHAR(10)&B1

I expect the result in C1 to be

The Olympics
2008

But, I have

The Olympics 2008

I don't get the ALT+ENTER effect using CHAR(10) for line feed.

What have I missed?  Thanks.

Epinn
Biff - 28 Oct 2006 21:56 GMT
Format C1 to wrap text. Initially, you may see this:

The
Olympics
2008

Then widen the column and you'll get what you want.

ALT ENTER automatically wraps text but you would still need to widen the
column.

Biff

A1:  The Olympics
B1:   2008
C1:  =A1&CHAR(10)&B1

I expect the result in C1 to be

The Olympics
2008

But, I have

The Olympics 2008

I don't get the ALT+ENTER effect using CHAR(10) for line feed.

What have I missed?  Thanks.

Epinn
RagDyeR - 28 Oct 2006 22:00 GMT
Don't you see a small square between Olympics and 2008?

"Olympics2008"

You have to now format the cell to "Line Wrap"

Signature

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

A1:  The Olympics
B1:   2008
C1:  =A1&CHAR(10)&B1

I expect the result in C1 to be

The Olympics
2008

But, I have

The Olympics 2008

I don't get the ALT+ENTER effect using CHAR(10) for line feed.

What have I missed?  Thanks.

Epinn
Epinn - 29 Oct 2006 00:05 GMT
Thank you all for your response.

I guess I expected more than CHAR(10) can deliver.  <g>

Yes, you can say I am inexperienced too.  <g>

RD, I don't see that small square before 2008.  Does everyone see it except me?
I use V. 2003; which version do you use?

Thanks.

Epinn

Don't you see a small square between Olympics and 2008?

"Olympics2008"

You have to now format the cell to "Line Wrap"

Signature

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

A1:  The Olympics
B1:   2008
C1:  =A1&CHAR(10)&B1

I expect the result in C1 to be

The Olympics
2008

But, I have

The Olympics 2008

I don't get the ALT+ENTER effect using CHAR(10) for line feed.

What have I missed?  Thanks.

Epinn
Biff - 29 Oct 2006 01:51 GMT
Screencap:

http://img329.imageshack.us/img329/5638/char10su5.jpg

Using Excel 2002

Biff

Thank you all for your response.

I guess I expected more than CHAR(10) can deliver.  <g>

Yes, you can say I am inexperienced too.  <g>

RD, I don't see that small square before 2008.  Does everyone see it except
me?
I use V. 2003; which version do you use?

Thanks.

Epinn

Don't you see a small square between Olympics and 2008?

"Olympics2008"

You have to now format the cell to "Line Wrap"

Signature

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

"Epinn" <someone@example.com.NO_SPAM> wrote in message
news:eSk%23CBt%23GHA.1784@TK2MSFTNGP04.phx.gbl...
A1:  The Olympics
B1:   2008
C1:  =A1&CHAR(10)&B1

I expect the result in C1 to be

The Olympics
2008

But, I have

The Olympics 2008

I don't get the ALT+ENTER effect using CHAR(10) for line feed.

What have I missed?  Thanks.

Epinn

Epinn - 29 Oct 2006 02:02 GMT
Thanks for the trouble, Biff.  Interesting, that little square disappears for Version 2003.

Probably won't exist for 2007 either?  I think it's good to get rid of it.

Epinn

Screencap:

http://img329.imageshack.us/img329/5638/char10su5.jpg

Using Excel 2002

Biff

Thank you all for your response.

I guess I expected more than CHAR(10) can deliver.  <g>

Yes, you can say I am inexperienced too.  <g>

RD, I don't see that small square before 2008.  Does everyone see it except
me?
I use V. 2003; which version do you use?

Thanks.

Epinn

Don't you see a small square between Olympics and 2008?

"Olympics2008"

You have to now format the cell to "Line Wrap"

Signature

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

A1:  The Olympics
B1:   2008
C1:  =A1&CHAR(10)&B1

I expect the result in C1 to be

The Olympics
2008

But, I have

The Olympics 2008

I don't get the ALT+ENTER effect using CHAR(10) for line feed.

What have I missed?  Thanks.

Epinn
joeu2004@hotmail.com - 28 Oct 2006 23:59 GMT
> A1:  The Olympics
> B1:   2008
[quoted text clipped - 11 lines]
> I don't get the ALT+ENTER effect using CHAR(10) for line feed.
> What have I missed?

I find that sometimes, I must select the cell and press F2 in order to
get the desired effect.  I do not know why.
Epinn - 29 Oct 2006 00:08 GMT
I format the cell as suggested and it works fine now.  No F2 needed.  
Which version do you have?  Do you see that little square that RD mentioned?  

Epinn

Epinn wrote:
> A1:  The Olympics
> B1:   2008
[quoted text clipped - 11 lines]
> I don't get the ALT+ENTER effect using CHAR(10) for line feed.
> What have I missed?

I find that sometimes, I must select the cell and press F2 in order to
get the desired effect.  I do not know why.
joeu2004@hotmail.com - 29 Oct 2006 02:17 GMT
> > I find that sometimes, I must select the cell and press F2 in order to
> > get the desired effect.  I do not know why.
>
> I format the cell as suggested and it works fine now.  No F2 needed.
> Which version do you have?  Do you see that little square that RD mentioned?

I am using Office Excel 2003; and yes, when the alt-Enter is
ineffective, I see a little square in the text.  Perhaps F2 is never
needed when Wrap Text is selected explicitly (checkmarked).  But it is
needed occassionally (and seemingly unpredictably) when Excel selects
Wrap Text implicitly -- which is indicated by a solid green box instead
of a checkmark next to Wrap Text under Format > Cells > Alignment.

Excel seems to select Wrap Text implicitly when alt-Enter is typed
initially.  Since I cannot cause the alt-Enter to be ineffective
predictably, I do not know if the implicit Wrap Text is deselected when
that happens.  But if I deselect Wrap Text explicity (leaving the
option uncheckmarked), the alt-Enter is ineffective, of course.
Pressing F2 causes Wrap Text to be selected implicitly again.  So I do
suspect when F2 is needed, it is because Excel had selected Wrap Text
implicitly, then deselected it implicitly for some inexplicable reason.

The point is:  If things work fine initially when you type alt-Enter,
then later they do not work, either selecting the cell and typing F2,
or explicitly selecting Wrap Text format should remedy the situation.
joeu2004@hotmail.com - 29 Oct 2006 02:33 GMT
joeu2...@hotmail.com wrote:
> Perhaps F2 is never
> needed when Wrap Text is selected explicitly (checkmarked).  But it is
> needed occassionally (and seemingly unpredictably) when Excel selects
> Wrap Text implicitly -- which is indicated by a solid green box instead
> of a checkmark next to Wrap Text under Format > Cells > Alignment.

The green box in the Wrap Text option apparently indicates that Wrap
Text was selected (implicitly) for some, but not all of several cells
that were merged.

When I enter text that contains alt-Enter into a single cell, Wrap Text
is checkmarked automatically by Excel.

My experience has been that such single-cell alt-Enter text does indeed
lose its formatting occassionally and unpredicably.  Selecting the cell
and typing F2 (by the way, I really mean F2 Enter) has remedied the
problem when it has happened in the past (just hours ago!).

As an experiment, when I deselect Wrap Text explicitly, Wrap Text
becomes uncheckmarked; then selecting the cell and typing F2 causes
Wrap Text to be selected again.

But once again, because I am unable to predictably cause alt-Enter to
become ineffective automatically (i.e. by Excel, not me) when I have
not selected Wrap Text explicitly, I cannot say with impunity that F2
is needed occassionally when you select Wrap Text explicitly.

You might simply file this information away in the recesses of your
mind, just in case it becomes necessary.
Epinn - 29 Oct 2006 02:41 GMT
I am quite lost with this talk of implicit, explicit, solid green box etc. etc.  I only wonder about one thing.  Both of us use 2003, how come I don't see a little square with CHAR(10) before format>alignment>wrap text?  However, I won't waste time on this and I'll just let it go.

Epinn

Epinn wrote:
> <joeu2004@hotmail.com> wrote:
> > I find that sometimes, I must select the cell and press F2 in order to
> > get the desired effect.  I do not know why.
>
> I format the cell as suggested and it works fine now.  No F2 needed.
> Which version do you have?  Do you see that little square that RD mentioned?

I am using Office Excel 2003; and yes, when the alt-Enter is
ineffective, I see a little square in the text.  Perhaps F2 is never
needed when Wrap Text is selected explicitly (checkmarked).  But it is
needed occassionally (and seemingly unpredictably) when Excel selects
Wrap Text implicitly -- which is indicated by a solid green box instead
of a checkmark next to Wrap Text under Format > Cells > Alignment.

Excel seems to select Wrap Text implicitly when alt-Enter is typed
initially.  Since I cannot cause the alt-Enter to be ineffective
predictably, I do not know if the implicit Wrap Text is deselected when
that happens.  But if I deselect Wrap Text explicity (leaving the
option uncheckmarked), the alt-Enter is ineffective, of course.
Pressing F2 causes Wrap Text to be selected implicitly again.  So I do
suspect when F2 is needed, it is because Excel had selected Wrap Text
implicitly, then deselected it implicitly for some inexplicable reason.

The point is:  If things work fine initially when you type alt-Enter,
then later they do not work, either selecting the cell and typing F2,
or explicitly selecting Wrap Text format should remedy the situation.
joeu2004@hotmail.com - 29 Oct 2006 04:54 GMT
> I am quite lost with this talk of implicit, explicit, solid green box etc.

Sorry about that.  I was writing more for the experienced MVP, in the
hopes that someone might be able to explain what __I__ am seeing.

(I was also trying to be helpful to you insofar as giving you a
heads-up about the potential future need to use F2.)

> Both of us use 2003, how come I don't see a little square with CHAR(10) before format>alignment>wrap text?

Hmm, I wonder if there is an option that controls that behavior?  None
that I can find.  And I __think__, but I cannot be sure, that I also
have not see the little square __sometimes__ when I know that it is
there.

> However, I won't waste time on this and I'll just let it go.

Agreed!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.