C
Connie
I am trying to create a macro to find and insert a "special character" without changing the current text. Example: I have a list of names, addresses and SSN's. I was able to create a macro that would FIND: SSN and REPLACE with a paragraph mark. However, I now have a name without a SSN.
Is there a way to FIND: "State" "Zip Code" and if "SSN" does not appear after "Zip Code", insert "special character" after the "Zip Code" without changing any text?
Is there a way to FIND: "State" "Zip Code" and if "SSN" does not appear after "Zip Code", insert "special character" after the "Zip Code" without changing any text?