ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Search for "Alt-Enter" character (https://www.excelbanter.com/excel-discussion-misc-queries/170407-search-alt-enter-character.html)

jkiser

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?



Dave Peterson

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

David Biddulph[_2_]

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?





jkiser

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



All times are GMT +1. The time now is 03:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com