After searching through the forum I couldn't find any leads for what I want to do. I figure there's a way to do this without going to REGEX.
I would like to replace the non-alphabetical and non-numerical characters (those other than [a-z][A-Z][0-9]) with "" for the contents of cell A1.
Can anyone point me to a previous post or provide some code to get me going? I am using Excel 2007.
Thanks in advance.