![]() |
#4
|
||||
|
||||
![]()
Most of this can be done by:
Find: ^13(Qty[0-9]{1,})^13 Replace With: " \1 " without the quotes but with spaces either side of the \1 You can add Format>Paragraph>Alignment=Left to the Replace With box to make sure the result aligns left. A separate find replace can be used to bring the return($ onto the same line. For that one you can: Find: ^13(\($) Replace with: " \1"
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macro to search names/ids and replace text in another column | Kalü | Excel Programming | 1 | 12-06-2018 07:14 PM |
Adding terms to a search & replace macro | Ulodesk | Word VBA | 6 | 03-29-2018 05:30 AM |
Macro on Search and Replace | davidhuy | Word VBA | 1 | 12-19-2014 04:47 AM |
![]() |
rohanrohith | Word VBA | 3 | 11-27-2014 01:08 PM |
Search and Replace - Clear Search box | JostClan | Word | 1 | 05-04-2010 08:46 PM |