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
-----Original Message-----
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?
.
|