About 1,784,613 results (1,735 milliseconds)
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 ... For example, the following text appears in a cell. I want to remove everything except the characters to the right of the forward slash (B123456) ...
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 ...
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 ...
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 ... ... character in E10 and return all the characters up to and including the digit before the letter P. If error(…,$E10) says that if the above ...
When I insert a table in a doc, it moves the entire text to the next ...
https://support.google.com/docs/thread/136094083/when-i-insert-a-table-in-a-doc-it-moves-the-entire-text-to-the-next-page?hl=en Nov 19, 2021 ... ... character of text, it moves to the first character on the next page. ... In the new copy of the document remove any sensitive information, or ...
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 ... The pasted text is Unix/MacOS terminal shell output. I cannot find any automated formatting method to make it look correct and am forced to ...
Split text, remove duplicates, or trim whitespace - Computer - Google ...
https://support.google.com/docs/answer/6325535?hl=en&co=GENIE.Platform%3DDesktop Split data into columns · At the top, click Data and then Split text to columns. · To change which character Sheets uses to split the data, next to "Separator" ...
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 ... See if you can delete any invisible characters from the last character to the end of the cell. ... before text entry then it works as expected.
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. ... All that said, at least Excel displays something ...
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. Solution : 1. back up your spreadsheet ;)!. 2. in a separate cell / separate column ...
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 ... What I want to do is have the sheet check if the last characters match any of my previous criteria but only remove them if there are no letters ...
How can I delete a section break in Google Docs. The backspace ...
https://support.google.com/docs/thread/3822385/how-can-i-delete-a-section-break-in-google-docs-the-backspace-key-will-not-delete-the-section?hl=en Apr 8, 2019 ... View section breaks first to make it clear where you need to select above. For a Mac, you need to use the fn + delete (this is the delete ...
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 ...
How do I remove a green bar inserted in my document. It reveals my ...
https://support.google.com/docs/thread/2898313/how-do-i-remove-a-green-bar-inserted-in-my-document-it-reveals-my-name-when-i-scroll-over-it?hl=en Mar 23, 2019 ... since i rejected it, it just deleted all the text i had added since the accidental right click.
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 ...
Large space that I cannot delete in my document! - Google Docs ...
https://support.google.com/docs/thread/6485484/large-space-that-i-cannot-delete-in-my-document?hl=en May 20, 2019 ... Did you remove the dummy text below the heading without replacing it? ... In the new copy of the document remove any sensitive information, or ...
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 ... before the number so I can know the currency that is being used.
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 ... All Replies (3) ... The secret to this is to put a single apostrophe before you type the plus sign and it will show up without the apostrophe.
TinyDB/File cmpnnt: the best way to import/export in csv (without ...
https://groups.google.com/g/mitappinventortest/c/RYDOHNQ54cw Mar 25, 2015 ... then before saving to csv, replace all comma by a pipe and replacing the weird UFT8 (actually it's a star!) symbol by comma.