can macro edit text?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LydiaD - 26 Oct 2006 05:28 GMT

I would like to convert a large number of e-mail addresses from one naming
convention to another... ex "Jwilliams@yahoo.com" needs to become
"williaj@aol.com". 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.

Reply to this Message

Stefi - 26 Oct 2006 08:11 GMT

This formula will do that:
=MID(A8,2,6)&LEFT(A8)&"@aol.com"

Regards,
Stefi

> I would like to convert a large number of e-mail addresses from one naming
> convention to another... ex "Jwilliams@yahoo.com" needs to become
> "williaj@aol.com". 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.

Reply to this Message

David Biddulph - 26 Oct 2006 12:30 GMT

Yes, but you and the OP may want to think about how you wish to deal with
Jsmith@yahoo.com

Signature

David Biddulph

> This formula will do that:
> =MID(A8,2,6)&LEFT(A8)&"@aol.com"
>
> Regards,
> Stefi

>> I would like to convert a large number of e-mail addresses from one
>> naming
>> convention to another... ex "Jwilliams@yahoo.com" needs to become
>> "williaj@aol.com". 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.

Reply to this Message

Stefi - 26 Oct 2006 13:41 GMT

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

Regards,
Stefi

„David Biddulph” ezt írta:

> Yes, but you and the OP may want to think about how you wish to deal with
> Jsmith@yahoo.com
[quoted text clipped - 10 lines]
> >> characters and 1 first initial. Can I use a macro for this? Any advice
> >> would be appreciated.

Reply to this Message

David Biddulph - 26 Oct 2006 14:20 GMT

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"

Signature

David Biddulph

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

> "David Biddulph" ezt írta:
>
>> Yes, but you and the OP may want to think about how you wish to deal with
>> Jsmith@yahoo.com

>> > This formula will do that:
>> > =MID(A8,2,6)&LEFT(A8)&"@aol.com"
[quoted text clipped - 10 lines]
>> >> advice
>> >> would be appreciated.

Reply to this Message

Stefi - 26 Oct 2006 14:54 GMT

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:

> 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
[quoted text clipped - 25 lines]
> >> >> advice
> >> >> would be appreciated.

Reply to this Message

LydiaD - 26 Oct 2006 19:00 GMT

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

Sincerely,
Lydia

> 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
[quoted text clipped - 34 lines]
> > >> >> advice
> > >> >> would be appreciated.

Reply to this Message

Stefi - 27 Oct 2006 07:38 GMT

You are welcome! Thanks for the feedback!
Stefi

> I am very grateful to both you and David B. What a collaboration! Thanks
> for sharing your knowledge.
[quoted text clipped - 40 lines]
> > > >> >> advice
> > > >> >> would be appreciated.

Reply to this Message