![]() |
|
#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
|
|||
|
|||
![]() Quote:
Good job! Thanks! |
#8
|
||||
|
||||
![]()
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 |
#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] |
![]() |
|
![]() |
||||
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 |
![]() |
QA_Compliance_Advisor | Word VBA | 11 | 09-11-2014 11:51 PM |
![]() |
Hoxton118 | Word VBA | 7 | 06-10-2014 05:05 AM |
![]() |
paulkaye | Word | 4 | 12-06-2011 11:05 PM |
![]() |
shabbaranks | Excel | 4 | 03-19-2011 08:38 AM |