Replace ALT+ENTER from multiple text cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to export an excel sheet to a text file for import into a web
application. some text cells are formatted with ALT+ENTER and other
formatting controls.
I need to replace these with either html tags or the space character.
How can I do this?
 
Select the range, press Ctrl+H, hold down the ALT key and
type in "0010" (no quotes) on your numeric keypad. Press
TAB and in the "Replace With" box hold down the ALT key
and type "0032" (no quotes). Press "Replace All".

HTH
Jason
Atlanta, GA
 
Back
Top