View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Deleting LF Characters in cells

NBSP character is DEC 160 or HEX A0


Gord

On Wed, 19 Mar 2008 17:01:25 -0500, Dave Peterson
wrote:

Hex 160 is HTML's non-breaking space character



BillH wrote:

<<snipped
Using that code it says the character is '160'. I have used an
external hex editor and it said the character is an x'0A'. Now I'm
even more confused.- Hide quoted text -

- Show quoted text -


I tried Find Alt-0160 and replaced with blank and it worked! Thanks
all.