| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using replace box to change a character into a CR (Alt-Enter c
Thanks. I couldn't find that anywhere. It works great!
"Dave Peterson" wrote: Select your range edit|replace what: (your special character) with: ctrl-j (hit and hold the control key and hit the j key) replace all ctrl-j is the same as hitting and holding the alt-key and typing 0010 on the numeric keypad. Excel user wrote: How do I use the edit/replace menu to replace some character with alt-enter character? Trying to do this in Excel 2003. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| enter text in cell and have value change in all worksheets; with l | Excel Discussion (Misc queries) | |||
| Change Excel Find & Replace Options Defaults | Excel Discussion (Misc queries) | |||
| How do I change a data series from bars to lines in an Excel char. | Charts and Charting in Excel | |||
| Copy a column in worksheet with a character change | Excel Worksheet Functions | |||
| The number change from 1350 to 13.5 and Enter does not function properly | Excel Discussion (Misc queries) | |||
Hybrid Mode
