In a large data file, multiple users have added phone numbers to cells with a "=" instead of a "+" creating formulas. Ex. below:
observed
=206-555-1212
expected
+206-555-1212
Is there a way to copy and paste, replacing the "=" with "+" in one column?
observed
=206-555-1212
expected
+206-555-1212
Is there a way to copy and paste, replacing the "=" with "+" in one column?