Find and Replace

kjxavier · #5 08-10-2011, 10:07 PM

Quote:

Originally Posted by macropod

Hi kjxavier,

Try a wildcard Find/Replace, where:
Find = ([0-9]{3}-[0-9]{4})([0-9]{2})
replace = \1 \2

Hi!

I have many Email ID's converted from some software.
But for some ID's there are Case Problems

E.g.: RUBLE@MSN.COM this is OK(let the Capital Mail ID's contain Cap Extension)

But : becky@msn.COM this ID should be becky@msn.com
St.navygary3@aol.COM should be St.navygary3@aol.com

how can solve the Extension Case Problem using WildCard

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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 and replace graphics	thegeester	Drawing and Graphics	0	04-04-2010 04:36 AM
Find /Replace Help	ilcaa	Word	2	11-02-2009 08:41 AM