Hi kjxavier,

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

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Yup, That helped a lot.

thanx Mr. Paul Edstein

Dat helped me....

Can i have "DOUBLE SPACE" after the .com , .org , .biz or any three characters after the DOT of any E-mail Address.
So that i can Replace my Double Spaces to Tab Character and take it to another field in my XL sheet.

Example1: rawls@msn.comSAN DIEGO to rawls@msn.com SAN DIEGO
Example2: paulgirard@optonline.netsanta rosa to
paulgirard@optonline.net santa rosa


I just need 2 spaces after any three Characters after the DOT in only email address fields. (there are many dots in the line other than email) somethng like @ followed by a DOT(.)



xavier

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