26 мая 2022 г. · I have a spreadsheet with a bunch of links. I'd like to remove all the text after "/" in each link to leave me with just the plain link.

20 янв. 2023 г. · You want Sheets to go through cells A1:A4, and delete -BL only when it shows up at the end of a string. I'm assuming: BL will always show up after a hyphen.

9 сент. 2022 г. · I was thinking a function that could read the cell from right to left and delete every character to the left of the first forward slash would do the trick.

4 сент. 2019 г. · I have a list of files with path names (for example, "file1.pdf, file2.pdf, file3.pdf" and so on) and I need to remove the ".pdf" part from each ...

5 июн. 2024 г. · I would like to remove a specific amount of characters from a text string for an entire sheet. The number of characters I need to remove is ...

17 июл. 2024 г. · Remove last part of a string in a cell. Solved. I have a sheet with names and values at the end but I don't want the values at the end.

23 дек. 2023 г. · CTRL+H is the hot key for windows. COMMAND+SHIFT+H for Macs to get to the find/replace window.

4 мар. 2020 г. · I want to remove the first 11 characters and the last 4 characters of a string within a cell. The cells go upto 20k rows so definitely need a formula for it.

19 апр. 2023 г. · As long as it's consistent with a space between the date and the time, use the space as the separator.

27 апр. 2024 г. · Select what you need, openSearch and replace dialog (CTRL+H), tick Regular expression checkbox, then put ^.(.*) to search and \1 to replace.