Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using replace box to change a character into a CR (Alt-Enter char)
How do I use the edit/replace menu to replace some character with alt-enter
character? Trying to do this in Excel 2003. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using replace box to change a character into a CR (Alt-Enter char)
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 |
#3
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) |