Thread: removing the "ALT+ENTER"?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
  
Posts: 1,726
Default removing the "ALT+ENTER"?
=SUBSTITUTE(A1,CHAR(10),"")

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"salvo00" wrote in message
...
How can I remove the "ALT+ENTER - line break" from a list of cells ?


Reply With QuoteReply With Quote