indieman
03-16-2007, 07:48 AM
Hi,
Im am creating an excel application to automate a manual task that is taking 10 minutes to do, but i have run into a problem. The last step i need is to save the file in a certain format.
I need to know how to split up a text string and re-arrange it. For example i need
Andrew Smith --> Smith, Andrew
Robert Samuel Read --> Read, Robert Samuel
Sarah Chaggar-Brown --> Chaggar-Brown, Sarah
Can anybody help? The amount of times this manual process happens means if i can automate it I'll save us 50 man hours a week, it will look good on my one-to-one.
Thanks,
Ben
Im am creating an excel application to automate a manual task that is taking 10 minutes to do, but i have run into a problem. The last step i need is to save the file in a certain format.
I need to know how to split up a text string and re-arrange it. For example i need
Andrew Smith --> Smith, Andrew
Robert Samuel Read --> Read, Robert Samuel
Sarah Chaggar-Brown --> Chaggar-Brown, Sarah
Can anybody help? The amount of times this manual process happens means if i can automate it I'll save us 50 man hours a week, it will look good on my one-to-one.
Thanks,
Ben