| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can macro edit text?
You are welcome! Thanks for the feedback!
Stefi "LydiaD" wrote: I am very grateful to both you and David B. What a collaboration! Thanks for sharing your knowledge. Sincerely, Lydia "Stefi" wrote: 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. |
| 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 | |||
Threaded Mode
