| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using replace to get rid of paragraph return character
I have a non-functioning paragraph return symbol at the end of all my text
strings (from info I pulled off the web). ^p in the replace box doesn't get rid of them. Any ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using replace to get rid of paragraph return character
Try Alt+0182 in the find box. (Hold down ALT key, 0182 must be typed from
numeric keypad.) If they are the actual symbol, rather than returns, that should find them. "Raku" wrote: I have a non-functioning paragraph return symbol at the end of all my text strings (from info I pulled off the web). ^p in the replace box doesn't get rid of them. Any ideas? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using replace to get rid of paragraph return character
alt+0182 brought up the return symbol in the find box (great to know, by the
way), but excel doesn't seem to recognize them as such. Is there a copy and paste function that can be used for the find box? Would they be easier to get rid of in another program (I've tried Word, no luck)? Thanks "BoniM" wrote: Try Alt+0182 in the find box. (Hold down ALT key, 0182 must be typed from numeric keypad.) If they are the actual symbol, rather than returns, that should find them. "Raku" wrote: I have a non-functioning paragraph return symbol at the end of all my text strings (from info I pulled off the web). ^p in the replace box doesn't get rid of them. Any ideas? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using replace to get rid of paragraph return character
Do ctrl + H, click in the find what box, hold down alt and type 0160 on the
numeric keypad, release the alt key leave the replace with box empty and select replace all -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "Raku" wrote in message ... I have a non-functioning paragraph return symbol at the end of all my text strings (from info I pulled off the web). ^p in the replace box doesn't get rid of them. Any ideas? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using replace to get rid of paragraph return character
Try Ctrl+j (or Alt+0010 on Numeric keypad) in the replace box maybe.
On 13 Apr, 06:26, Raku wrote: I have a non-functioning paragraph return symbol at the end of all my text strings (from info I pulled off the web). ^p in the replace box doesn't get rid of them. Any ideas? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using replace to get rid of paragraph return character
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. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using replace to get rid of paragraph return character
See your other post.
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. -- Dave Peterson |
|
#8
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. |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using replace to get rid of paragraph return character
have you tried copying the charater and pasting into find?
"Raku" wrote: I have a non-functioning paragraph return symbol at the end of all my text strings (from info I pulled off the web). ^p in the replace box doesn't get rid of them. Any ideas? |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using replace to get rid of paragraph return character
I've tried it, but I can't get the copy /paste function to work in the 'find
what' box in either excel or word. "bj" wrote: have you tried copying the charater and pasting into find? "Raku" wrote: I have a non-functioning paragraph return symbol at the end of all my text strings (from info I pulled off the web). ^p in the replace box doesn't get rid of them. Any ideas? |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using replace to get rid of paragraph return character
edit-paste doesn't but "Control v" will paste for me into find
"Raku" wrote: I've tried it, but I can't get the copy /paste function to work in the 'find what' box in either excel or word. "bj" wrote: have you tried copying the charater and pasting into find? "Raku" wrote: I have a non-functioning paragraph return symbol at the end of all my text strings (from info I pulled off the web). ^p in the replace box doesn't get rid of them. Any ideas? |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using replace to get rid of paragraph return character
Thank you! Perfect.
"bj" wrote: edit-paste doesn't but "Control v" will paste for me into find "Raku" wrote: I've tried it, but I can't get the copy /paste function to work in the 'find what' box in either excel or word. "bj" wrote: have you tried copying the charater and pasting into find? "Raku" wrote: I have a non-functioning paragraph return symbol at the end of all my text strings (from info I pulled off the web). ^p in the replace box doesn't get rid of them. Any ideas? |
| 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
