Forum Discussion
Remove Pilcrows in Word
I have a .docx table I want to open in Excel. However the .docx file contains a lot of Pilcrows. I thought I could just use find and replace in Word to remove them, otherwise the table apears as below, using Ctrl C and Ctrl V, with the text expanded to cover several Excel rows instead of just one.
I tried copying the pilcrow sysmbol into Find but replace does not find anything? I get the message We made 0 replacements in your selection.
Any advice please?
WORD
EXCEL
Select the table in Word.
Press Ctrl+H to activate the Replace dialog.
Enter ^p in the 'Find what' box. ^p is the code for a paragraph mark (displayed as a pilcrow in Word).
In the 'Replace with' box, enter something that doesn't otherwise occur in the table, for example @@@.
Click 'Replace All'.
Now copy and paste the table into Excel.
With the pasted table selected, ress Ctrl+H to activate the Replace dialog.
Enter @@@ in the 'Find what' box.
In the 'Replace with' box, press Ctrl+J. This will enter an invisible line break.
Click 'Replace All'.
Make sure that the 'Wrap Text' button on the Home tab of the ribbon is on (highlighted).
- Thank you for your reply. Howver it seems to add addition "Line feeds"
E.g. in the above example:-
M
6 miles
is now:-
M
6 miles
which throws out my formulae that use LEFT, RIGHT and MID to extract data.
How can I stop these additional "line feeds"Are you sure that you used the same text string in Word and in Excel?
If not, that might explain what you describe. For example, if you replace ^p with @@@ in Word, but then replace @ with Ctrl+J in Excel, each paragraph break would be replaced with 3 line breaks.
