![]() |
|
#1
|
|||
|
|||
|
Hi
How can i find and replace simultaneous ^t and ^p whit space. It is posible ? Thanks |
|
#2
|
||||
|
||||
|
You'll need two find & replace operations, that is, what you are asking can't be done in a single step.
__________________
Stefan Blom Microsoft Word MVP Microsoft 365 apps for business Windows 11 Professional |
|
#3
|
|||
|
|||
|
Quote:
thanks for reply |
|
#4
|
||||
|
||||
|
Even in a macro, two find & replace operations would be required, as far as I can tell. First replace tab characters (^t) with a blank space and then replace paragraph marks (^p) with a blank space. Note that you won't be able to get rid of the very last paragraph mark in a document, because that mark must always be present.
__________________
Stefan Blom Microsoft Word MVP Microsoft 365 apps for business Windows 11 Professional |
|
#5
|
|||
|
|||
|
Quote:
|
|
#6
|
||||
|
||||
|
It can be done with a single find and replace. As Stefan pointed out, it won't replace the final paragraph mark though
Find: [^t^13] Wildcards turned on.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
|
#7
|
||||
|
||||
|
Maybe I misunderstood the question. I apologize!
As Guessed pointed ut, of course you can find a tab character immediately followed by a paragraph mark.
__________________
Stefan Blom Microsoft Word MVP Microsoft 365 apps for business Windows 11 Professional |
|
#8
|
|||
|
|||
|
Quote:
Good job! Thanks! |
|
#9
|
||||
|
||||
|
Apparently I did misunderstand the question. :-(
If you don't need a wildcard find & replace, you can make use of ^t^p in the "Find what" box. You can even use ^w^p which would find any blank space (tab or space character) followed by a paragraph mark.
__________________
Stefan Blom Microsoft Word MVP Microsoft 365 apps for business Windows 11 Professional |
|
#10
|
|||
|
|||
|
Quote:
I want to convert a multiple columns (table numbers) from Excel into a single paragraph in Word (copy from Excel and paste in Word). Then in Word i use "find and replace" to replace all tabs and paragraphs between my numbers whit spaces character. ^ t ^ p does not work at once in my case but [^t^13] works |
|
#11
|
||||
|
||||
|
^t^p should definitely work, assuming that you type this string without including any spaces and, as stated previously, you will have to clear the "Use wildcard" option.
__________________
Stefan Blom Microsoft Word MVP Microsoft 365 apps for business Windows 11 Professional |
|
#12
|
|||
|
|||
|
Quote:
example below |
|
#13
|
||||
|
||||
|
Your example has no occurrences of a tab character immediately followed by a paragraph mark, which is why ^t^p isn't working.
That is a different kind of search compared to a wildcard search of [^t^13] which defines a range. See for example http://www.gmayor.com/replace_using_wildcards.htm.
__________________
Stefan Blom Microsoft Word MVP Microsoft 365 apps for business Windows 11 Professional |
|
#14
|
||||
|
||||
|
Try a wildcard Find/Replace, where:
Find =([0-9])^13([0-9]) Replace = \1^t\2 to insert tabs where the paragraph breaks are, or: Replace = \1^l\2 to insert line breaks instead.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| In Find and Replace, can Word stop after each Replace? | wardw | Word | 1 | 06-08-2017 02:47 PM |
VBA Batch Find & Replace for all MSOffice extensions, to replace File Name and Content of the File
|
QA_Compliance_Advisor | Word VBA | 11 | 09-11-2014 11:51 PM |
Find what box in Find and replace limits the length of a search term
|
Hoxton118 | Word VBA | 7 | 06-10-2014 05:05 AM |
Bad view when using Find and Find & Replace - Word places found string on top line
|
paulkaye | Word | 4 | 12-06-2011 11:05 PM |
Help with find and replace or query and replace
|
shabbaranks | Excel | 4 | 03-19-2011 08:38 AM |