Split Number to Digits in Google Sheets

0
391

You can split numbers to digits in a flash in Google Sheets. MID function is the solution for this. MID is a google sheet text function. Still we can use this text function to split number to separate digits. So what you are going to learn in this Google Sheet tutorial? An awesome trick to split number to digits in Google Sheets and the use of MID function in Google Sheets.

I will explain how to split number to digits in Google Sheets step by step. As already told you should know how to use MID function in Google Sheets. See the syntax and usage below.

Syntax:

MID(string, starting_at, extract_length)

Before explaining how can we split numbers to digits, see a simple example below.

Example:

=mid(“InfoInspired”,5,8)

The above MID function will produce the result “Inspired”. This is the answer to questions like how to extract or cut part of a word or sentence in Google sheets.

As per the syntax “InfoInspired” is the string. We extracted 8 characters from the character starting at 5th position, that is “I”. So the result will be “Inspired”.

That means we can extract any number of characters from any position of a given string. It’s applicable to numbers also as MID function considers numbers as string.

See How Can We Split Number to Digits in Google Sheets Using MID function below

As already mentioned above MID is a text function. The above same method in the case of splitting “InfoInspired” is applied for splitting numbers.

Prepare a spreadsheet as above. In cell A2 type the number 1234567 which we will split to individual numbers. Yep! Not characters.

We can use MID text function to split number and get the result in numbers by applying a small logic. How? Just multiply the result with 1. Use the above formula in the screenshot to split number digits in Google Sheets. I pick the formula in cell B2 below and explained it in detail.

MID function can extract number by number.

=mid(A2,2,1)

This will extract second digit from the number 1234567. As per the syntax 1234567 is the string, 2 is the position to start the extraction and 1 is the number of digits to be extracted. So the result is 2.

MID function considers numbers as string. So the result will be in text format. That is the reason we multiply the result with 1. See the example.

=mid(A2,2,1)*1

The above convert the number in text format to number format in Google Sheets.

Hope you understand the tricks to split numbers to digits in Google Spreadsheet.

Now there may be a genuine question arising in your mind. Why one should split numbers? We used this function in creating a number to word converter in Google Sheets. We can’t predict how can one use one function dynamically in spreadsheets. So it’s up to the users.

SHARE

A technology enthusiast and addictive blogger who likes to travel and wish to mingle with different community of people from around the world.