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
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
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
Here you get the names that are at least 18 characters long so click the arrow which is beside the length column.
Go to Number Filters > Greater Than or Equal To
There type in 18 and continue by clicking OK.