Plus Symbol in front of a phone number converts it into a formula
I have a list of over a thousand phone numbers in a google sheet. Many of these numbers have a plus symbol in the start. Google sheets is automatically converting this numbers to Formulas by replacing the + symbol with =
I read it here that adding an apostrophe ' in front of the number will make sure that google sheet will read it as a plain text and not a formula. But its not possible for me to manually add an apostrophe in front of each number.
Also, the numbers have spaces in them so google sheet is throwing an error in a lot of cases.
e.g.
When I enter +1 484 2918 914 , gsheet converts it into =1 484 2918 914 and throws an #ERROR because of the space.
How can I convert this formula into a plain text?
Thanks a lot
if you have your numbers lets say in one column and that column does not contains any valid formulae you can try with CTRL + H like:
- Not able to iterate through all the rows in 2D array in Row-Wise Binary Search
- How can I remove a specific item from an array in JavaScript?
- Get the last item in an array
- Searching for part of a string within an array
- Fastest way to convert Image to Byte array
- How to quickly find the minimum element to the right for every element of a Numpy array?
- JS sort array of pair with null and empty values at the end
- bash script to Echo multiple lists
- storing char in char array - incompatible types in assignment of char to char[]
- Inserting JSON data with 'insertAdjacentElement' instead of 'innerHTML'
- Extract associative array elements into individual variables
- How can I loop through enum values for display in radio buttons?
- Split a comma-delimited string into an array?
- How to transform array into desired output using jolt
- How to override only method signature in typescript?
- How do I remove an element from an array at a specified index but not do the operation in-place
- Using array values to select database table in laravel
- Custom Fields - Repeater dropdown - list only unique & not blank values
- Get taxonomies in a category archive page
- How can I compare a clicked elements ID with another ID?
- Unexpected memory allocation when using array views (julia)
- How can I check if a lua table contains only sequential numeric indices?
- Snowflake - challenge in accessing objects in an array
- Convert a Result Set from SQL Array to Array of Strings
- How to convert an array into an object?
- How do I know an array contains all zero(0) in Javascript
- JS create array from a sorted array of pairs
- Insert array into MySQL database with PHP
- How to explode only on the last occurring delimiter?
- Java two varargs in one method