Replace ALT+ENTER from multiple text cell

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?
 
J

Jason Morin

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search and replace ALT+Enter 4
Search for "Alt-Enter" character 3
Search & Replace to insert alt+<enter> 7
Unicode text and carriage returns 4
Copy & Paste cell that has alt + enter 2
Formatting Text in one cell Vertically 3
Using replace box to change a character into a CR (Alt-Enter char) 2
formatting for mail merge 1

Top