Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alt + Enter Character Number
Hi
why not use 'Edit - Replace' for this. In the search box hold down the ALT key and enter 0010 -- Regards Frank Kabel Frankfurt, Germany Simon Shaw wrote: I have a spreadsheet that contains cells where I used Alt + Enter to soft-return within a Cell so information would appear on two lines. However, the spreadsheet needs to be saved as a Tab delimited Text file. This Alt + Enter causes a carrige return character in the text file which causes me problems. I want to write a quick macro to search the cells in the spreadsheet and replace the Alt + Enter character with a space. is there a character number for the Alt + Enter? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding Character number for ALT-Enter | Excel Worksheet Functions | |||
How can I change the color of the cell when someone enter any number or character? | New Users to Excel | |||
How can I change the color of the cell when someone enter any number or character? | Charts and Charting in Excel | |||
How do I create a new symbol to enter as a character? | Excel Worksheet Functions | |||
DDE an Alt-Enter (Newline) character | Excel Programming |