| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using replace to get rid of paragraph return character
phil
Alt + 0010 in the "replace with" box will give you a CR in the cell. Must be typed in using the NumPad at right, not the number keys above qwerty. You don't want Alt 0160.......that is non-breaking space. Alternative to Alt + 0010 is CTRL j Gord Dibben MS Excel MVP On Thu, 10 May 2007 12:23:05 -0700, philr wrote: I have a similar problem but I need to put the hard paragraph back into the text which was copied over from Word into Excel. In the Replace with box I've tried alt 0010, alt 0182, alt 0160 (all on the number pad) but each time I get an error saying "formula too long." The alt 0182 shows the hard paragraph symbol but I get the message. The alt 0160 shows a period. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find/replace paragraph mark | Excel Discussion (Misc queries) | |||
| replace new line character | Excel Discussion (Misc queries) | |||
| How do I replace a BEL Character of 7 with a space | Excel Discussion (Misc queries) | |||
| How to remove or replace a carriage return character in a cell? | Excel Discussion (Misc queries) | |||
| How do I replace a character with another? | Excel Discussion (Misc queries) | |||
Hybrid Mode
