VAndre
New Member
- Joined
- Dec 7, 2005
- Messages
- 42
I'm writing a little macro that needs to copy a string from one place to another. In the process, I need it to truncate the name after any characters like " " or "-".
Not all entries will have either character in them... some will but not all
I started by trying to use the Application.worksheet.FIND, but that breaks when one of the characters isn't present.
Any help would be appreciated! I'm trying to simplify the question, so please assume that I really do need to do this in VBA and can't just use Edit/Find&Replace or a simple function solution.
Thanks!
Andre
Not all entries will have either character in them... some will but not all
I started by trying to use the Application.worksheet.FIND, but that breaks when one of the characters isn't present.
Any help would be appreciated! I'm trying to simplify the question, so please assume that I really do need to do this in VBA and can't just use Edit/Find&Replace or a simple function solution.
Thanks!
Andre