Ad Code

Showing posts with the label ExcelShow all
Use This Excel Function to Slugify / Handle-ize Any Text — Useful for Bulk URL Creation

Use This Excel Function to Slugify / Handle-ize Any Text — Useful for Bulk URL Creation

Excel June 16, 2025

Periodically I run into the issue where I need to create a lot (thousands) of URLs from random strings of text, which …

Removing first two digits in Excel if the character length is greater than certain number

Removing first two digits in Excel if the character length is greater than certain number

Excel April 10, 2023

You're not using the parenthesis properly. Also since you strictly want to have 10 characters, you don't need t…

How to export an HTML table as a .xlsx file

How to export an HTML table as a .xlsx file

Excel February 26, 2021

I have a question about exporting an   HTML table   as an   xlsx   file. I did some work and now I can export it as an …

How to remove 91 from mobile number in excel

How to remove 91 from mobile number in excel

Excel July 23, 2018

Worksheet Formulas Cell Formula B2…

Duplicate Values in an Excel List

Duplicate Values in an Excel List

Excel January 02, 2018

F rom time to time, you may need to identify duplicate values with a list in Excel. Modern versions, including Excel 2…

How To Extract Username From Email Addresses In Excel

How To Extract Username From Email Addresses In Excel

Excel December 11, 2017

As we all know, email address contains two parts which are user name and domain name. But, in certain case, you may ne…

Counting duplicates in Excel

Counting duplicates in Excel

Excel October 03, 2017

I have a list of postcodes that includes duplicates. I would like to find out how many instances of each postcode ther…

Load More That is All