About 1,475,604 results (5,032 milliseconds)
TRIM function - Google Docs Editors Help
https://support.google.com/docs/answer/3094140?hl=en ... after the text are significant. TRIM removes all spaces in a text string, leaving just a single space between words. Whitespace or non-breaking space will ...
Inputting anything into a cell increases the spacing. What's going on ...
https://support.google.com/docs/thread/3897639/inputting-anything-into-a-cell-increases-the-spacing-what-s-going-on?hl=en Apr 9, 2019 ... find a cell with text (not formula) ... backspace to remove all of the text; type in new text; hit enter. A new line, char(10) is inserted after ...
Remove double spacing between paragraphs - Google Docs Editors ...
https://support.google.com/docs/thread/123763579/remove-double-spacing-between-paragraphs?hl=en Aug 31, 2021 ... Then I selected "add space after paragraph" to make all of them the same. Next, with all text still selected, I pressed "remove space after ...
Extract text from string after 2nd comma - Google Docs Editors ...
https://support.google.com/docs/thread/98354641/extract-text-from-string-after-2nd-comma?hl=en Feb 16, 2021 ... Hi all, In Cell A1 I have a string of text - eg: Camlok CH Horizontal Plate Clamp, Smooth Jaw, 5-32mm, 1000kg WLL
REGEX + ARRAYFORMULA to remove characters or strings using ...
https://support.google.com/docs/thread/124123583/regex-arrayformula-to-remove-characters-or-strings-using-dynamic-cell-references?hl=en Sep 2, 2021 ... They are not familiar with spreadsheet formulas, so I would like to simplify this a bit by letting them enter multiple text strings or ...
Search and use find and replace - Computer - Google Docs Editors ...
https://support.google.com/docs/answer/62754?hl=en&co=GENIE.Platform%3DDesktop To replace the word every time it's used, click Replace all. Find and replace items using regular expressions. You can find and replace strings of text, ...
How do I mass remove line breaks in Google Docs? - Google Docs ...
https://support.google.com/docs/thread/4814034/how-do-i-mass-remove-line-breaks-in-google-docs?hl=en Apr 24, 2019 ... ... all text in one cell - say a cell in Column C, cell C1 ... - define a formula to string all rows of col B together to fit in cell C1. - ...
Make SUM function ignore text - Google Docs Editors Community
https://support.google.com/docs/thread/141753178/make-sum-function-ignore-text?hl=en Dec 22, 2021 ... I'm trying to use the SUM function to add all cells from the "E" column, yet it only will work if it doesn't have any text and I need it to have the "R$" ...
Alignment stuck in Google Sheets. - Google Docs Editors Community
https://support.google.com/docs/thread/5688420/alignment-stuck-in-google-sheets?hl=en May 7, 2019 ... ... text. See if you can delete any invisible characters from the last character to the end of the cell. You can also use the =LEN(A2) formula ...
Using substitute to remove text only if it is the end of the string ...
https://support.google.com/docs/thread/189756234/using-substitute-to-remove-text-only-if-it-is-the-end-of-the-string?hl=en Nov 22, 2022 ... After going through this the output is "SMITH/JOHN". . However this ... Delete all formulas that have below this formula in that column.
Is it possible for a plus sign to show as plain text and not create a ...
https://support.google.com/docs/thread/4057005/is-it-possible-for-a-plus-sign-to-show-as-plain-text-and-not-create-a-formula?hl=en Apr 12, 2019 ... I need the plus sign to show as plain text and not create a formula. Is there any way to do that? Details. Sheets,Mac OS,Business. Locked.
How to use find+replace to replace newline (\n) with soft linebreak or ...
https://support.google.com/docs/thread/9648924/how-to-use-find-replace-to-replace-newline-n-with-soft-linebreak-or-vertical-tab-v?hl=en Jul 10, 2019 ... ... text such as (\v) (^v) (^l). I cannot get the replace function to accept the special character as a replacement. The pasted text is Unix ...
Giant blank space in document - tried removing all format, normal ...
https://support.google.com/docs/thread/37309312/giant-blank-space-in-document-tried-removing-all-format-normal-text-no-spacing?hl=en Apr 1, 2020 ... I have tried clearing all format, removed all spaces before and after paragraphs, set the text type to normal... I am so frustrated I'm ...
Why are line breaks being added to cells randomly? - Google Docs ...
https://support.google.com/docs/thread/19672393/why-are-line-breaks-being-added-to-cells-randomly?hl=en Nov 13, 2019 ... find a cell with text (not formula) · place the cursor in the edit line (formula bar) · backspace to remove all of the text · type in new text · hit ...
Split text, remove duplicates, or trim whitespace - Computer - Google ...
https://support.google.com/docs/answer/6325535?hl=en&co=GENIE.Platform%3DDesktop To change which character Sheets uses to split the data, next to "Separator" click the dropdown menu. To fix how your columns spread out after you split your ...
Ran into an "uncleanable" character in Google Sheets. This is a bug ...
https://support.google.com/docs/thread/51299987/ran-into-an-uncleanable-character-in-google-sheets-this-is-a-bug?hl=en Jun 4, 2020 ... ... remove them after pasting into a cell, that should preserve the invisible characters. ... The CLEAN() function should be expanded to remove all " ...
I would like to know how to delete letters from a column of cells ...
https://support.google.com/docs/thread/118001572/i-would-like-to-know-how-to-delete-letters-from-a-column-of-cells-without-moving-the-numbers?hl=en Jul 21, 2021 ... The formula to extract the text from Column E is in cell F10. ... all the characters up to and including the digit before the letter P.
How to remove unwanted spaces - Google Docs Editors Community
https://support.google.com/docs/thread/188915830/how-to-remove-unwanted-spaces?hl=en Nov 16, 2022 ... I have tried the "TRIM" formula, but it only removed some spaces and did not remove ALL spaces between the characters as needed.
Need a formula to remove the text from a cell, and just leave the ...
https://support.google.com/docs/thread/56218448/need-a-formula-to-remove-the-text-from-a-cell-and-just-leave-the-numbers?hl=en Jun 29, 2020 ... \D \\ is a RegEx metadata character, meaning not a digit. ... In this case I used \D so all not digit are replace woth nothing leaving only digits ...
How do I remove random strings of text from Google Sheet cells ...
https://support.google.com/docs/thread/21249935/how-do-i-remove-random-strings-of-text-from-google-sheet-cells?hl=en Nov 26, 2019 ... I have tried using wildcards and formulas to select the random string of characters ... Replace to automatically strip out everything before the " ...