Find and Replace

kjxavier · #3 07-24-2011, 09:16 AM

Hi!

The Second Widcard worked perfect.

But the First one for E-mail ID has some prob i quess

! At a place it worked but not on all fields of mail id. All i need is DOUBLE SPACES before and after email.

is there anything wrong with the way i did.

Anyways can you help me with the attached file please and a WILDCARD for the same

Regards and Thanks you for the same
Xavier

Quote:

Originally Posted by macropod

hi xavier,

For an email address preceded by one or more spaces, try a wildcard Find/Replace where:
Find = "[ ]{1,}([! \@]{1,}\@*.[! ]{1,})[ ]{1,}"
Replace = " \1 "

For the alpha-numeric strings, try a wildcard Find/Replace where:
Find = "<[A-Z]{2}[0-9]{6}>"
Replace = "^&"
and set the colour format the replacement as red.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find and Replace	kjxavier	Word	9	08-11-2011 04:47 AM
Help with find and replace or query and replace	shabbaranks	Excel	4	03-19-2011 08:38 AM
find and replace	anil3b2	Word	0	08-03-2010 11:30 PM
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