Extract Length Of the Text Using Power Query

In excel if you want to extract the length of your text then you can use power query or get & transform to complete it within some simple steps.

I am going to take it as an example as mentioned in following example sheet.

You can also browse our Power Query Tutorial Catalog here.

NOTE 1: You can create random excel workbook online here for practice purposes as I did in this tutorial.

NOTE 2: If You use Microsoft Excel Prior to 2016 Version, then You Need to download Power Query Separately.

Previously In Power Query: How to Count Rows by Power Query?

There you go with the steps to follow:

STEP1. Firstly, select your data and press the shortcut Ctrl + T or by going to Insert > Table then it will turn into Excel Table

Extract Length Of the Text

STEP2. Now in the second step follow this procedure:

For Office 365 or After 2016: Go to Data > Get & Transform > From Table 

For Excel 2013 & 2010: Power Query > Excel Data > From Table

Count Rows Using Power Query

STEP3. Now you have your power query editor then follow this:

Select the any (or email in my case) column and Go to Add Column > From Text> Extract > Length

Extract Length Of the Text

Here you get the names that are at least 18 characters long so click the arrow which is beside the length column.

Extract Length Of the Text

Go to Number Filters > Greater Than or Equal To

Extract Length Of the Text

There type in 18 and continue by clicking OK.

Extract Length Of the Text

STEP4. Now from the Home tab click the close & load option to open a new worksheet in your Excel with your filtered records.

Extract Length Of the Text