View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave T Dave T is offline
external usenet poster
 
Posts: 6
Default HARD RETURN IN A CELL

I have a spreadsheet that was exported from Outlook or word and has a hard
return represented by the symbol of a square. It looks like in Outlook they
had a street address, hard return and then suite number. I need to go through
the spread sheet and delete each hard return in order to leave all the same
data in one cell. Can this hard return be removed, without going through each
record?

Thank you.