I need to make a macro remove the 7th character in a string of text if the
first 6 letters match the specified criteria. But I don't know the best way
to handle...

This is what I want to do:
If the first 6 characters of a2="Albany", then delete the next character
(which in this case is ",").

If the above isn't true...then continue on with the remainder of the macro.

And continue to the next row.