LEN Function Archives - Page 2 of 2

How to Remove Last Character from String in Google Sheets

August 3, 2023 Basics

In Google Sheets, a cell may occasionally include both a numeric number and a non-numeric character. You do not want the non-numeric character in ...

How to Remove Last Character from String in Google Sheets

How to Get Rid of Dollar Sign in Google Sheets (3 Effective Ways)

August 3, 2023 Basics

You might occasionally see cells that have a dollar sign in them. However, if you attempt to edit the cells, the dollar sign will not be there to be ...

How to Get Rid of Dollar Sign in Google Sheets (3 Effective Ways)

How to Remove First Character in Google Sheets

August 10, 2023 Basics

As humans, it's in our nature to either add or subtract something from our daily lives. The same is true when using Google Sheets. There are a few ...

How to Remove First Character in Google Sheets

Google Sheets: Sum if Cell is Not Blank

October 31, 2022 Basics

In this tutorial, we will look at how to sum if a cell is not blank in Google Sheets over a range of cells. The Basic Way to Sum if a Cell is Not ...

How to Remove Characters from a String in Google Sheets (6 Easy Examples)

April 5, 2023 Basics

Updating data can involve both adding and removing other data to it. Things become trickier when we have hundreds of updates to perform, which is a ...

How to Remove Characters from a String in Google Sheets (6 Easy Examples)

Google Sheets Smart Fill: Recognize and Autocomplete Patterns (A Complete Guide)

August 2, 2022 Basics

If you’ve been following recent updates, you will know about the new AI-powered addition to Google Sheets, the Smart Fill. In this article, we ...

Google Sheets Smart Fill: Recognize and Autocomplete Patterns (A Complete Guide)

Find All Cells With Value in Google Sheets (An Easy Guide)

April 13, 2023 Basics

In this simple tutorial, we will show you how you can find all cells with value in Google Sheets. Be it any value or specific value (text or ...

Find All Cells With Value in Google Sheets (An Easy Guide)

Character Count in Google Sheets (An Easy Guide)

April 4, 2022 Basics

Knowing how to perform a character count in Google Sheets can often come in handy in many situations. And today we will look at some of these ...

Character Count in Google Sheets (An Easy Guide)

Count Non-Empty Cells in Google Sheets (4 Easy Ways)

March 22, 2023 Basics

The ability to recognize and count non-empty cells in Google Sheets is very crucial if you are looking to avoid some silly errors. And today, we will ...

Count Non-Empty Cells in Google Sheets (4 Easy Ways)

Reference Another Sheet in Google Sheets (4 Easy Ways)

March 30, 2023 Basics

Today, we look at how to reference another sheet in Google Sheets. While it does sound easy (and it is), it’s common to see users of all levels of ...

Reference Another Sheet in Google Sheets (4 Easy Ways)

Using COUNTIF to Count Non-Blank Cells in Google Sheets

January 10, 2022 Basics

Counting non-blank cells in a spreadsheet is a fairly common affair at every level of the profession. There are many ways to go about it. But today, ...