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? |
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? . |
All times are GMT +1. The time now is 10:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com