Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Replace ALT+ENTER from multiple text cell
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? |
#2
|
|||
|
|||
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? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make a cell recognize multiple text strings? | Excel Worksheet Functions | |||
how do I enter multiple lines in a cell in Excel | Excel Discussion (Misc queries) | |||
Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
how to hyperlink text to a cell | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions |