About 1,881,812 results (2,222 milliseconds)
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 ... Each day I will be pasting in new data in the rows below, if I use the split Data function to move the letters and numbers into different cell, ...
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 ... Need a formula to remove the text from a cell, and just leave the numbers. Hello, I have a column with thousand of entries in the following ...
Phone number giving Formula Parse Error - Google Docs Editors ...
https://support.google.com/docs/thread/74709430/phone-number-giving-formula-parse-error?hl=en Oct 4, 2020 ... Is there a way to display as plain text or remove the + automatically? Any formulas I try (RIGHT, SUBSTITUTE etc) just throw the same error. I ...
remove or hide #VALUE! from cells - Google Docs Editors Community
https://support.google.com/docs/thread/113554404/remove-or-hide-value-from-cells?hl=en Jun 14, 2021 ... It says #VALUE! in all the cells (until a number is added in the cell you want the multiplication applied to). How can i remove or hide the #VALUE! text from ...
I have a column of phone numbers, but all start with "p:+". How can I ...
https://support.google.com/docs/thread/14297761/i-have-a-column-of-phone-numbers-but-all-start-with-p-how-can-i-remove-p-from-column?hl=en Sep 13, 2019 ... I just want the raw number, but I also have 123 rows and don't want to go through and manually delete the "p:+" from each one. Is there a way to ...
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 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 ... Hey, so I have some data I would like to work with the SUM function to get the total amount for each column, but since the data is like ...
How can I convert copied text with numbers to actual numbers for ...
https://support.google.com/docs/thread/40936947/how-can-i-convert-copied-text-with-numbers-to-actual-numbers-for-calculations?hl=en Apr 18, 2020 ... Copying in the numbers into both Google Sheets and Excel 365 does not allow me to use the pasted numbers in formula's. ... cell and remove the ...
Auto formating causing #ERROR! for phone number entries in a ...
https://support.google.com/docs/thread/21952036/auto-formating-causing-error-for-phone-number-entries-in-a-spreadsheet?hl=en Dec 4, 2019 ... Select the column with the phone numbers in it then press Ctrl+H to open the find and replace. Then change the "Search" to specific range and it should show ...
All text in every cell of Google Sheet is permanently bold. How Can I ...
https://support.google.com/docs/thread/79450940/all-text-in-every-cell-of-google-sheet-is-permanently-bold-how-can-i-disable?hl=en Oct 27, 2020 ... You may find a rule has been set up to Bold face cells, maybe any cell with any value, or any number etc. You can delete a CF rules via the ...
Remove certain data from a phone number in cell that is being ...
https://support.google.com/docs/thread/26234712/remove-certain-data-from-a-phone-number-in-cell-that-is-being-added-to-the-sheet-automatically?hl=en Jan 20, 2020 ... Is there a way to use a formula to remove that +1, or only take the last 10 digits in that cell? Details. Sheets,Mac OS,Personal use.
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.
I'm getting #ref when deleting rows. Is there a way to avoid this ...
https://support.google.com/docs/thread/84417645/i-m-getting-ref-when-deleting-rows-is-there-a-way-to-avoid-this?hl=en Nov 21, 2020 ... I'm not too familiar with excel or google sheets. ... For example, if I create a formula like =Sum(A2+A3+A4+A5) and delete row 3, the A3 cell is ...
I cannot remove the color green from the latest date cells after ...
https://support.google.com/docs/thread/50103626/i-cannot-remove-the-color-green-from-the-latest-date-cells-after-inputting-the-date?hl=en May 30, 2020 ... Here's how to remove the green fill color. Highlight cells C508:C512 and then go to Format > Conditional formatting.
How to remove decimal places from cells formatted as text - Google ...
https://support.google.com/docs/thread/265531791/how-to-remove-decimal-places-from-cells-formatted-as-text?hl=en Mar 23, 2024 ... I'm using this function in Google Sheets to strip a letter from the end of numbers in a range of cells, sum the numbers in that range of cells, and then divide ...
Can I prevent down-fill from incrementing *every* cell reference in a ...
https://support.google.com/docs/thread/5225132/can-i-prevent-down-fill-from-incrementing-every-cell-reference-in-a-formula?hl=en Apr 30, 2019 ... At the end of each row I have a formula that computes a useful number ... A3") will ALWAYS point to that cell even if you add/delete rows or ...
Number with £ sign is always text and no way to convert - Google ...
https://support.google.com/docs/thread/11215683/number-with-%C2%A3-sign-is-always-text-and-no-way-to-convert?hl=en Aug 3, 2019 ... Yes, there are workarounds, but this sort of issues doesn't happen in Excel ... I created another tab and entered the following formula in cell B2 ...
Have values in cells with checkboxes checked to subtract from ...
https://support.google.com/docs/thread/5461399/have-values-in-cells-with-checkboxes-checked-to-subtract-from-another-cell-and-then-be-summed?hl=en May 4, 2019 ... When checked the value in the cell will be subtracted from another cell. ... I have a column with numbers and next to them a column with check- ...
Delete duplicate rows in some columns and leave data in other ...
https://support.google.com/docs/thread/130347062/delete-duplicate-rows-in-some-columns-and-leave-data-in-other-columns?hl=en Oct 11, 2021 ... Column E = Phone Number (duplicate values) Column F = Address ... I was trying to apply your formula in my excel version of the report.
How to replace numbers and words with only numbers in google ...
https://support.google.com/docs/thread/262569292/how-to-replace-numbers-and-words-with-only-numbers-in-google-sheets?hl=en Mar 6, 2024 ... I have to replace 12576 cells of numbers and words with only the numbers that are already there. Can someone post an exact description of how that can be done ...