#1
|
|||
|
|||
Selective Find and Replace in addresses
HI All
I have a lot of addresses which I'm trying to tidy via search and replace in VBA. Essentially , where there is a ", " (comma space) I want to replace this with a carriage return. I use ^p to do this. Unfortunately , this disrupts the address incorrectly when there is a comma space following numbers. Example ; John Smith 11, My Street, Anytown becomes John Smith 11 My Street Anytown When it should be John Smith 11, My Street Anytown I tried using advanced 'any character' formulas , but they incorrectly replace the first letters of the words. Can someone advise how to make the carriage retrurn active where the comma space follows a letter , and not when it follows a number? Grateful for any advice. |
#2
|
||||
|
||||
You could use a wildcard Find/Replace, where:
Find = ([!0-9]), Replace =\1^p
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Hi
Ok thanks for that - that's got it working fine. It puts a carriage return for letters but not for numbers , which is perfect. Many thanks. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Bad view when using Find and Find & Replace - Word places found string on top line | paulkaye | Word | 4 | 12-06-2011 11:05 PM |
Is there a way to use "find/replace" to find italics words? | slayda | Word | 3 | 09-14-2011 02:16 PM |
Help with find and replace or query and replace | shabbaranks | Excel | 4 | 03-19-2011 08:38 AM |
help with find and replace | sjkiss | Word | 1 | 04-12-2010 08:08 AM |
Find /Replace Help | ilcaa | Word | 2 | 11-02-2009 08:41 AM |