Home |
Search |
Today's Posts |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I search and replace with a line break?
I'm not quite sure what your question means, but you can also use ctrl-j instead
of alt-0010 in both the edit|replace dialog as well as the Other character in the data|text to columns dialog. Kathy wrote: Chip, Is it possible to change the line break to "Text to Columns" "Chip Pearson" wrote: In the "Find What" box of the Replace dialog, hold down your left ALT key and type 0010 on the numeric keypad (not the number keys above the letters). -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "Impish" wrote in message ... Want to use Ctrl-H to replace a specific character in a range of cells with a line break (Alt+Enter) - how do I access special characters? (^p didn't work) -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ALT+ENTER = line break | Excel Discussion (Misc queries) | |||
Search and Replace end of Line and Insert Alt-Enter | Excel Discussion (Misc queries) | |||
Break cell into multiple lines by line break | Excel Discussion (Misc queries) | |||
Line Break | Excel Discussion (Misc queries) | |||
line break in a cell | Excel Worksheet Functions |