can macro edit text?

L

LydiaD

I would like to convert a large number of e-mail addresses from one naming
convention to another... ex "[email protected]" needs to become
"[email protected]". The finished product should consist of six lastname
characters and 1 first initial. Can I use a macro for this? Any advice
would be appreciated.
 
S

Stefi

You are right, this formula solves the problem:
=MID(A7,2,SEARCH("@",A7)-2)&LEFT(A7)&"@aol.com"

Regards,
Stefi

„David Biddulph†ezt írta:
 
D

David Biddulph

That solves my case, but doesn't address the OP's original example for which
you gave your first answer. I guess that it probably needs to combine the
two?
=MID(A7,2,MIN(SEARCH("@",A7)-2,6))&LEFT(A7)&"@aol.com"
 
S

Stefi

That's true, I was in a hurry and didn't test it for both cases! Your
combined formula seems to solve both cases! I hope Lydia will be satisfied
with the result of our discussion!

Regards,
Stefi

„David Biddulph†ezt írta:
 
L

LydiaD

I am very grateful to both you and David B. What a collaboration! Thanks
for sharing your knowledge.

Sincerely,
Lydia
 
S

Stefi

You are welcome! Thanks for the feedback!
Stefi

LydiaD said:
I am very grateful to both you and David B. What a collaboration! Thanks
for sharing your knowledge.

Sincerely,
Lydia
Click to expand...
 
Top