About 1,403,626 results (3,630 milliseconds)
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 ... To fix how your columns spread out after you split your text, click the menu next to "Separator" ...
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. ... The text below the table (and probably throughout your document) ...
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 has the problem of removing those characters if they show up anywhere in ...
How do I remove the gray background around text. Each line is ...
https://support.google.com/docs/thread/14742531/how-do-i-remove-the-gray-background-around-text-each-line-is-backed-in-gray-not-the-whole-doc?hl=en Sep 18, 2019 ... Not the whole document, just each line. Tried to copy and paste an example below but the gray disappears when I paste in below.. Date this ...
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 ... ... character that is removed is the forward slash. For example, the following text appears in a cell. I want to remove everything except the ...
Space after a bullet changes and I can't figure out why. - Google ...
https://support.google.com/docs/thread/257088892/space-after-a-bullet-changes-and-i-can-t-figure-out-why?hl=en Feb 4, 2024 ... The text after the bullets that are single numbers starts within one spaces, like so: "(#) abcde..." However, the text after the bullet with ...
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 ... Note that this method will only work for you if the Column E cells are fully numeric or if they have the characters PED (or at least P) after ...
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 ... I have a column with thousand of entries in the following format "Grave moss 3369", I need a way to remove the text and be left with the integers (3369).
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. ... Excel with the CLEAN function and I found the following.
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.
Conditional formatting: remove cell highlight if cell in next column ...
https://support.google.com/docs/thread/33397994/conditional-formatting-remove-cell-highlight-if-cell-in-next-column-contains-text?hl=en Mar 13, 2020 ... When column D has text/dates in it, I'd like column C's formatting to be blank. So, if something was due yesterday, but the work was submitted ...
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 ... A typical string looks like ++AC+GJ++KCD++BC+A, but the pasted text has spaces between some characters and no spaces between others. My goal is ...
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 ...
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 ...
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
Docs keeps automatically adding a space after paragraph in my ...
https://support.google.com/docs/thread/16410311/docs-keeps-automatically-adding-a-space-after-paragraph-in-my-tables?hl=en Oct 9, 2019 ... ... remove (or add/remove) space after paragraphs? Thanks ... You have to select the text then go to Format - Line Spacing - Remove, etc.
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 ... I cannot get the replace function to accept the special character as a replacement. The pasted text is Unix/MacOS terminal shell output. I ...
This has to be simple, but how do I turn off insert, or overwrite of text ...
https://support.google.com/docs/thread/3653333/this-has-to-be-simple-but-how-do-i-turn-off-insert-or-overwrite-of-text-in-cells?hl=en Apr 5, 2019 ... If You have No Insert Key - Just click the cell & Remove num-lock and press 0 on the numpad. It will switch you from Overwrite mode to Insert ...
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. ... Excel with the CLEAN function and I found the following.
Need help removing letters from numbers to work with SUM function ...
https://support.google.com/docs/thread/202696449/need-help-removing-letters-from-numbers-to-work-with-sum-function-example-100m-removing-m?hl=en Feb 19, 2023 ... I need help with a function that can remove the letter "m" so it can add up the numbers because when i try to find the sum of numbers that have the letter "m" ...