Eliminating Hard Returns

  • Thread starter Thread starter Amy
  • Start date Start date
A

Amy

I have a very large spreadsheet and I need to remove all
hard returns quickly and effectively. Does anyone know of
a way to do this? Thanks.
 
Are the hard returns cause by alt-enters?

If yes,
Select your range to change (ctrl-A for the whole sheet)
Edit|replace
Find What: alt-0010
(hit and hold the altkey and type 0010 from the number keypad--not above the
QWERTY keys)

replace with: (nothing or a single space bar????)
Replace all.
 
Back
Top