I have numbers stored in a sheet as (xxx) xxx-xxxx. I want to remove all formatting and make it just xxxxxxxxxx.
How can I accomplish this?
Google Sheets – Change Number Stored to Plain Text Format
formattinggoogle sheets
Related Topic
- Google-sheets – Google sheets recently changed American datetime format, how to change it back
- Google-sheets – Custom Number Format for scale-aware number formatting in Google Sheets (e.g. 1,200→ 1.2k; 1,200,000 → 1.2M; 1,200,000,000 → 1.2B)
- Google-sheets – Convert Number and Text to Number
- Google-sheets – Google Sheets – conditionally format a cell based on whether the content of the cell appears in a column from a different sheet
- Google Sheets Formatting – Why Can’t These Strings Be Formatted as Numbers?
Best Answer
Please try:
REGEXREPLACE