About 1,206,431 results (3,043 milliseconds)
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 You can split clearly defined data, like text separated by commas, into several columns with Google Sheets. For example, a column ...
Remove text but keep numbers including decimal point - Google ...
https://support.google.com/docs/thread/41566729/remove-text-but-keep-numbers-including-decimal-point?hl=en Apr 21, 2020 ... should do it - single array formula. have thow trim in for luck. Original Poster Jason Davies 1478 marked this as an answer. Helpful? 2.
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).
How do I use the trim formula uniquely within conditional formatting ...
https://support.google.com/docs/thread/68379310/how-do-i-use-the-trim-formula-uniquely-within-conditional-formatting?hl=en Sep 1, 2020 ... the 1* will force what was the "text" you got from the right side into a number. If the range to be applied is WIDER, like you want to highlight ...
TRIM function - Google Docs Editors Help
https://support.google.com/docs/answer/3094140?hl=en text - The string or reference to a cell containing a string to be trimmed. Notes. Google Sheets trims text input into cells by default. It is important to use ...
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 ... This array formula would be able to remove multiple strings/characters simultaneously, but I am unsure how to do this with REGEXREPLACE with more than one ...
Data validation trim formula - Google Docs Editors Community
https://support.google.com/docs/thread/261118201/data-validation-trim-formula?hl=en Feb 28, 2024 ... In cell B2, the data validation rule prevents someone from entering text with leading or trailing spaces. For the rest of column B, it just ...
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.
Is there any way to have text colors stay as is when I cut & paste a ...
https://support.google.com/docs/thread/61658077/is-there-any-way-to-have-text-colors-stay-as-is-when-i-cut-paste-a-cell-to-another-place-on-sheet?hl=en Jul 29, 2020 ... ... cut & paste a cell to another place on sheet? In some case I need to mark certain numbers and words with certain colors (text, not the cell ...
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 ... My input string is formatted as such: "Lastname/FirstnameSalutation" i.e. "SMITH/JOHNMR". This is output as a single cell and I have gotten that ...
How to preserve formatting when cut and pasting across pages ...
https://support.google.com/docs/thread/136237697/how-to-preserve-formatting-when-cut-and-pasting-across-pages?hl=en Nov 19, 2021 ... ... Cut operation is a fresh new default cell. And by default, numeric values align right and text values align left. Paste Special. After you Cut ...
I need to remove specific characters in a column - Google Docs ...
https://support.google.com/docs/thread/23306258/i-need-to-remove-specific-characters-in-a-column?hl=en Dec 19, 2019 ... I have a list of cell phone numbers and I have like to filter them so that I can match the ones that repeat and decide which to take out and which to keep.
Why does "Split text to columns" split the text into rows for me ...
https://support.google.com/docs/thread/115619661/why-does-split-text-to-columns-split-the-text-into-rows-for-me?hl=en Jul 1, 2021 ... ... text into columns, i.e. vertically. But it's been splitting the text horizontally; I'm left having to cut and paste each individual cell in ...
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 ...
? How to AUTOMATICALLY FIT the Row Height to accommodate the ...
https://support.google.com/docs/thread/10178653/how-to-automatically-fit-the-row-height-to-accommodate-the-actual-text-in-the-cell-s-in-the-row?hl=en Jul 18, 2019 ... I want the height of all each of the rows to be adjusted to automatically fit the text (based on the cell with the largest amount of text in it) ...
Consolidating multiple text strings to one cell - Google Docs Editors ...
https://support.google.com/docs/thread/96349785/consolidating-multiple-text-strings-to-one-cell?hl=en Feb 2, 2021 ... Using autocrat to fill in portions of of google doc for actual report (originally used word/excel ... I substitute and trim to get rid of the ...
Comparing blank cell with a cell containing '0' is equating to TRUE ...
https://support.google.com/docs/thread/75135122/comparing-blank-cell-with-a-cell-containing-0-is-equating-to-true-all-of-a-sudden?hl=en Oct 6, 2020 ... ... cells actually contain zero-length text strings — i.e., "" . ... Delete in that cell (with the exception of array formula result cells.).
In google sheets can I set it so that all cells word wrap and align at ...
https://support.google.com/docs/thread/4372413/in-google-sheets-can-i-set-it-so-that-all-cells-word-wrap-and-align-at-top-by-default?hl=en Apr 17, 2019 ... User 2022919467423908018 yeah, control shift V works to create a default to text wrap for every cell. ... column is "cut". I suggest more ...
Date not overflowing to adjacent cells and formatting error when ...
https://support.google.com/docs/thread/25869880/date-not-overflowing-to-adjacent-cells-and-formatting-error-when-copied-and-pasted-to-another-sheet?hl=en Jan 16, 2020 ... The exception is with spreadsheets converted from Microsoft Excel where the default font is Calibri. ... The formula adds a text string to ...
XMPIE uDirect XMPPOSTNET drops leading zeros from zip codes
https://groups.google.com/g/xmpie-users/c/1FRNgVsHRvg have formatted the zipcode column in Excel as text, numerical, general and ... newly inserted column is "N". In cell N2 enter this formula: =if(len(trim(m2))<6, ...