| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search for "Alt-Enter" character
I used the "alt-enter" keys to force the word-wrap in text for a number of
cells. I want to undo this word-wrapping but don't want to seek out every cell where it occurs and manually un-word-wrap the text. Can I do this with the "Replace" function?....if so, how do I search for the character that is created by the "alt-enter" key combination? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Search for "Alt-Enter" character
You can use ctrl-j in the edit|Find or edit|Replace dialogs.
jkiser wrote: I used the "alt-enter" keys to force the word-wrap in text for a number of cells. I want to undo this word-wrapping but don't want to seek out every cell where it occurs and manually un-word-wrap the text. Can I do this with the "Replace" function?....if so, how do I search for the character that is created by the "alt-enter" key combination? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Search for "Alt-Enter" character
Yes.
Control J -- David Biddulph "jkiser" wrote in message ... I used the "alt-enter" keys to force the word-wrap in text for a number of cells. I want to undo this word-wrapping but don't want to seek out every cell where it occurs and manually un-word-wrap the text. Can I do this with the "Replace" function?....if so, how do I search for the character that is created by the "alt-enter" key combination? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Search for "Alt-Enter" character
Terrific!
"Dave Peterson" wrote: You can use ctrl-j in the edit|Find or edit|Replace dialogs. jkiser wrote: I used the "alt-enter" keys to force the word-wrap in text for a number of cells. I want to undo this word-wrapping but don't want to seek out every cell where it occurs and manually un-word-wrap the text. Can I do this with the "Replace" function?....if so, how do I search for the character that is created by the "alt-enter" key combination? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =IF(ISERROR(SEARCH("insurance",A125,1)),"","*") | Excel Worksheet Functions | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! | Excel Discussion (Misc queries) | |||
| Make "Edit" mode default, rather than "Enter"? | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Linear Mode
