8 февр. 2021 г. · I'm currently using the formula: =REGEXREPLACE(D2,"[[:punct:]]", " ") However this removes all punctuation and I need the periods to remain.

29 окт. 2020 г. · You can use =REGEXREPLACE(REGEXREPLACE(B222;"^\D+|\D+$"; ""); ",(\d+)\."; ".$1,"). Details. REGEXREPLACE(...;"^\D+|\D+$"; "") will remove ...

9 янв. 2022 г. · I need to replace spaces with a -, then remove any periods or parentheses. This is where I am at now, which works for spaces but not sure where to go for ...

20 дек. 2022 г. · The regex for a trailing period would be \.$ Now I don't know if that will work in Google Docs. The \ is the escaping character, ...

21 окт. 2022 г. · I want to remove the first and last characters of a text in a cell. I know how to remove just the first or the last with formulas such as =LEFT(A27, LEN(A27)-1)

24 июл. 2014 г. · In OpenOffice Calc, one can change number format between standard United States, with decimal separator being a period . , and the SI (International System) ...

26 дек. 2018 г. · I have a column of messy data within Google Sheets I'm trying to clean up and remove any non-numeric characters except decimals.

14 окт. 2021 г. · In LibreOffice using format "0.##" removes unnecessary decimal point, but Google Sheets don't. If you know how to do it, please share your ...

29 мая 2022 г. · Using TRIM removes trailing spaces AND trailing line breaks. It even removes both if they happen to coexist. On your example it is the height of ...

30 июн. 2020 г. · I'm trying to loop a function with different variables which are phone numbers from a column in google sheets. I can loop it if I leave the data as is.