For some reason I can't get this to work. Any help is appreciated
AccountSSName1 = John Smith DOD [1234-1234]
Out of that string I want to:
#1 - replace "[" & "]" with "(" & ")" so I can later name a tab of the worksheet with this value
#2 - just keep the 1234-1234
Keep in mind the value in...