View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
TGV TGV is offline
external usenet poster
 
Posts: 63
Default How do I remove ALT+ENTER in same cell?

It can be done in two ways:-

1) you can manually go to the end of ur cell data and give delete to remove
it.
2) If the data is more then use this formula to remove the ALT+ENTER

=CLEAN(TRIM(A1))

change the cell reference A1 to ur desired Cell.

--
If this post helps, pls click Yes
---------------
TGV


"Govindareddy" wrote:

I have hit ALT+ENTER to seperate lines in same cell. I need to remove this -
don't know how to remove this from a saved file.