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 belo...
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"
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.
- Thank you for your answer. Sorry I did not come back ealier but am under some other pressures so cannot allow all time I should for this application.