Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,688
Default char(160) -  

Hi Folks!

This character is called a non-breaking space. What exactly does
non-breaking mean?

Thanks

Biff


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,593
Default char(160) -  

An NBSP is used to prevent automatic line breaks, so a line like 'this is a
line with a non-breaking space' will never break between the 'with' and
the 'a'. IN HTML it is used to pad out with spaces, because a normal space
gets reduced to a single space.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Biff" wrote in message
...
Hi Folks!

This character is called a non-breaking space. What exactly does
non-breaking mean?

Thanks

Biff




  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 418
Default char(160) -  

Biff wrote:
This character is called a non-breaking space. What exactly does
non-breaking mean?


Go to google.com and enter "define: non-breaking space" without the
quotes.

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,688
Default char(160) -  

Thanks, Bob!

Biff

"Bob Phillips" wrote in message
...
An NBSP is used to prevent automatic line breaks, so a line like 'this is
a
line with a non-breaking space' will never break between the 'with'
and
the 'a'. IN HTML it is used to pad out with spaces, because a normal space
gets reduced to a single space.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Biff" wrote in message
...
Hi Folks!

This character is called a non-breaking space. What exactly does
non-breaking mean?

Thanks

Biff






  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,688
Default char(160) -  

Thanks! I just learned something about Google, define: something.

Biff

wrote in message
ps.com...
Biff wrote:
This character is called a non-breaking space. What exactly does
non-breaking mean?


Go to google.com and enter "define: non-breaking space" without the
quotes.





  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default char(160) -  

And you can do the same kind of thing in MSWord.

Say you have a part number that has embedded spaces in it and you don't want the
line to break at one of those spaces, you can use ctrl-shift-spacebar and it'll
be a non-breaking space.

And same thing with hyphens. ctrl-shift-hyphen is that character.

Inside MSWord, Insert|SymbolSpecial characters if you forget.



Biff wrote:

Hi Folks!

This character is called a non-breaking space. What exactly does
non-breaking mean?

Thanks

Biff


--

Dave Peterson
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,688
Default char(160) -  

Thanks, Dave!

Biff

"Dave Peterson" wrote in message
...
And you can do the same kind of thing in MSWord.

Say you have a part number that has embedded spaces in it and you don't
want the
line to break at one of those spaces, you can use ctrl-shift-spacebar and
it'll
be a non-breaking space.

And same thing with hyphens. ctrl-shift-hyphen is that character.

Inside MSWord, Insert|SymbolSpecial characters if you forget.



Biff wrote:

Hi Folks!

This character is called a non-breaking space. What exactly does
non-breaking mean?

Thanks

Biff


--

Dave Peterson



  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,572
Default char(160) -  

FWIW,

Char(173) is a non-breaking hyphen.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Biff" wrote in message
...
Thanks, Dave!

Biff

"Dave Peterson" wrote in message
...
And you can do the same kind of thing in MSWord.

Say you have a part number that has embedded spaces in it and you don't
want the
line to break at one of those spaces, you can use ctrl-shift-spacebar

and
it'll
be a non-breaking space.

And same thing with hyphens. ctrl-shift-hyphen is that character.

Inside MSWord, Insert|SymbolSpecial characters if you forget.



Biff wrote:

Hi Folks!

This character is called a non-breaking space. What exactly does
non-breaking mean?

Thanks

Biff


--

Dave Peterson




  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,593
Default char(160) -  

I had forgotten that, thanks for the memory jolt.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Dave Peterson" wrote in message
...
And you can do the same kind of thing in MSWord.

Say you have a part number that has embedded spaces in it and you don't

want the
line to break at one of those spaces, you can use ctrl-shift-spacebar and

it'll
be a non-breaking space.

And same thing with hyphens. ctrl-shift-hyphen is that character.

Inside MSWord, Insert|SymbolSpecial characters if you forget.



Biff wrote:

Hi Folks!

This character is called a non-breaking space. What exactly does
non-breaking mean?

Thanks

Biff


--

Dave Peterson



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I remove Char(160) from a cell? Dave Excel Worksheet Functions 2 February 3rd 05 02:06 PM


All times are GMT +1. The time now is 02:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"