Character Removal from Cell

[roriol]

This seems easy enough but has turned out to be hard nut to crack. I'm tweaking a form built in Excel 2010. User inputs their name in cell L61, and the name of their show in cell L64. The value for these two cells gets concatenated to become the file name.

All works great until they enter < > ? { } : | or * in either field. Then it blows up. I've looked at lots of solutions, and they all seem to involves mountains of code that I cannot decipher, or also pull out characters that are not a problem. Seems like there much be a simple way check a cell for only these characters, and if found, just remove them.

Thanks for any help on this

Robert

 

[shg]

Your using VBA? Maybe just delete them?

someString = replace(somestring, "<", "")
someString = replace(somestring, ">", "")
someString = replace(somestring, "?", "")
...

 

[roriol]

Your using VBA? Maybe just delete them?

someString = replace(somestring, "<", "")
someString = replace(somestring, ">", "")
someString = replace(somestring, "?", "")
...

Yep - that did it. Thanks!

 

[shg]

You're welcome.