| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can macro edit text?
I would like to convert a large number of e-mail addresses from one naming
convention to another... ex " needs to become ". 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can macro edit text?
This formula will do that:
" Regards, Stefi "LydiaD" wrote: I would like to convert a large number of e-mail addresses from one naming convention to another... ex " needs to become ". 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can macro edit text?
Yes, but you and the OP may want to think about how you wish to deal with
-- David Biddulph "Stefi" wrote in message ... This formula will do that: " Regards, Stefi "LydiaD" wrote: I would like to convert a large number of e-mail addresses from one naming convention to another... ex " needs to become ". 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can macro edit text?
You are right, this formula solves the problem:
" Regards, Stefi €žDavid Biddulph€ ezt Ã*rta: Yes, but you and the OP may want to think about how you wish to deal with -- David Biddulph "Stefi" wrote in message ... This formula will do that: " Regards, Stefi "LydiaD" wrote: I would like to convert a large number of e-mail addresses from one naming convention to another... ex " needs to become ". 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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can macro edit text?
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? " -- David Biddulph "Stefi" wrote in message ... You are right, this formula solves the problem: " Regards, Stefi "David Biddulph" ezt írta: Yes, but you and the OP may want to think about how you wish to deal with -- David Biddulph "Stefi" wrote in message ... This formula will do that: " Regards, Stefi "LydiaD" wrote: I would like to convert a large number of e-mail addresses from one naming convention to another... ex " needs to become ". 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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can macro edit text?
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 two? " -- David Biddulph "Stefi" wrote in message ... You are right, this formula solves the problem: " Regards, Stefi "David Biddulph" ezt Ã*rta: Yes, but you and the OP may want to think about how you wish to deal with -- David Biddulph "Stefi" wrote in message ... This formula will do that: " Regards, Stefi "LydiaD" wrote: I would like to convert a large number of e-mail addresses from one naming convention to another... ex " needs to become ". 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro linked to text or an object | Excel Discussion (Misc queries) | |||
| Text Search Macro? | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Copying Text to Clip Board Using a Macro | Excel Discussion (Misc queries) | |||
| copying text into a macro | Excel Worksheet Functions | |||
Hybrid Mode
