can macro edit text?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to convert a large number of e-mail addresses from one naming
convention to another... ex "(e-mail address removed)" needs to become
"(e-mail address removed)". 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.
 
Yes, but you and the OP may want to think about how you wish to deal with
(e-mail address removed)
 
You are right, this formula solves the problem:
=MID(A7,2,SEARCH("@",A7)-2)&LEFT(A7)&"@aol.com"

Regards,
Stefi

„David Biddulph†ezt írta:
 
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"
 
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:
 
I am very grateful to both you and David B. What a collaboration! Thanks
for sharing your knowledge.

Sincerely,
Lydia
 
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...
 
Back
Top