You are reading a single comment by @duncs and its replies.
Click here to read the full conversation.
-
Macro I think.
Or, to avoid nested then this is a little easier as it's just cut/paste a range.
But it's still a bit crap and it's pretty much nested anyway.
1 Attachment
-
duncs
-
Cheers. Think I'll probably go macro and incorporate creating the folders into the macro (I currently just paste it into a batch file).
@Chalfie Powerquery probably would do it neatly and just spit it out in a new table in the same spreadsheet. I may try that method if I get some free time as it's bound to cock up in some way.
aggi
I need to generate folder names based on client names. They're already in an Excel spreadsheet that gets updated from our billing system and creating the folders is easy enough. However, it's occurred to me that I need to strip out illegal characters.
I think there's about 10 of them so I don't really want to use a nested substitute function. Is there any other option to replace multiple characters or is down to using a macro?