#Carriage returns in excel symbols code#

Thanks so much for the response! It didnвЂ™t occur to me to use ^p, but thatвЂ™s a great idea! I ran some tests, and it worked like a charm. More on line feeds, carriage returns, end of paragraph marks etc.:

#Carriage returns in excel symbols code#

Interestingly, Wikipedia says that вЂIn ASCII and Unicode, the carriage return is defined as 13вЂІ ( ) but says nothing about the code for paragraphs/hard line returns. Now IвЂ™m not sure how all this would work in the macro my reader had created, but at least they now have something they know will work.ДЄll this testing was just in the normal Find/Replace dialog - no special settings at all. I added in some soft line returns, replaced ^l with ^13, then to see if ^p would work, I replaced ^13 with ^p and it worked! Those pesky carriage returns created from the ^l to ^13 replace changed to hard line returns when I replaced them with ^p. I did the test again, this time replacing ^l (soft line return) with ^p (hard line return), and the paragraph formatting changed to what it should be for each paragraph. I know that ^13 is often required when youвЂ™re doing a find/replace with wildcards as ^p doesnвЂ™t work (or at least, it doesnвЂ™t work under most circumstances). When I saved the doc as XML, I found вЂcrвЂ™ instead of вЂpвЂ™ where IвЂ™d done this find/replace, just as my worried reader had found. Sure enough, the pilcrow looks the same, but the paragraph formatting (paragraph above/below spacing mostly) wasnвЂ™t quite right. My first step in trying to solve the problem was to create a new Word document, add a couple of soft line returns and some normal paragraph returns, then do a find/replace on the soft line returns ( ^l - thatвЂ™s a lower case вЂLвЂ™) replacing them with ^13. Why is manually typing a paragraph working while find & replace is not? But IвЂ™d really like to understand whatвЂ™s happening (and why) with that find and replace. I found a solution, which is to search the document for pilcrows, select them, then type a paragraph. ItвЂ™s just that Word is accepting the command to insert a pilcrow, inserting it, but treating it like a carriage return. The paragraphs are all set to 12pts after, but none of them are actually displaying that space.

I went into the xml of the document, and sure enough there was instead of. The symbol on the screen is definitely a pilcrow-the same, filled-in black pilcrow IвЂ™m used to seeing at the end of a paragraph. WhatвЂ™s important here, and what I hope you can help with, is that when it makes a new pilcrow (IвЂ™m using ^13 in the find & replace), it treats it like a carriage return. Part of the macro runs a find and replace that deletes most of the pilcrows but retains them where it recognizes a paragraph. A lot of these conversions place a pilcrow at the end of each line, I guess because Word isnвЂ™t sure what else to do with a line break in a PDF. IвЂ™ve been working on a macro to clean up a document converted from PDF. One of my readers emailed me with a problem they couldnвЂ™t figure out.