New: NextGenTemplates Academy - video courses on Excel formulas with AI and Pivot Tables & dashboards. Early-bird: 20% off with code EARLYBIRD20 - first 20 orders only. See the courses →
  • Learn Excel (Free Course)
    • 1. Shortcut Keys
    • 2. Fill & Flash Fill
    • 3. Find & Replace
    • 4. Sort & Filter
    • 5. Formulas & Functions
    • 6. Data Validation
    • 7. Conditional Formatting
    • 8. Basic Charts
    • 9. Advanced Charts
    • 10. Pivot Tables
    • 11. Excel Dashboards
    • 12. VBA Course
    • 13. Excel Formulas with AI
  • Templates
  • Tutorials
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
    • Excel Dashboards
    • Power Pivot & DAX
  • Power BI
  • Template Store
    • Ready to Use Templates
  • Courses
  • Academy
    • Excel + AI Mastery: 100 Formulas
    • Excel Pivot Tables & Dashboards
  • About Us
  • Contact Us

PK: An Excel Expert

Transforming Data into Decisions

Tag: UDF

Add Space in name UDF
VBA

Discover the Magic Excel VBA UDF to Perfectly Space in Names

December 6, 2023October 10, 2026 PKComments Off on Discover the Magic Excel VBA UDF to Perfectly Space in Names
Introduction: The Power of VBA in Excel Excel, a powerhouse in data management and analysis, becomes even more potent with Visual Basic for Applications (VBA). This article will explore how
Read More
Ratio Calculation in Excel
Excel Tips and Tricks VBA

Calculate Ratio in Excel

January 23, 2020October 6, 2024 PKComments Off on Calculate Ratio in Excel
In this article, we have explained how to Calculate Ratio between two number in Excel. We have used the Excel formula as well as the User defined function in VBA to
Read More
RandBetweenText Formula in Excel: Random Text from a List
VBA

RandBetweenText Formula in Excel: Random Text from a List

December 4, 2019October 9, 2026 PKComments Off on RandBetweenText Formula in Excel: Random Text from a List
The RandBetweenText formula in Excel does for text what RANDBETWEEN does for numbers: it returns a random item from a list you choose, such as a random employee, product or
Read More
Word Count in Excel
VBA

UDF to get the frequency of specific word in a Paragraph

August 22, 2019October 10, 2026 PKComments Off on UDF to get the frequency of specific word in a Paragraph
I. Introduction Data analysis - a critical aspect of modern business and organizations - provides valuable insights into various datasets, allowing informed decisions to be made. While Microsoft Excel boasts
Read More
UDF to Fetch Comment Text in Excel Cell: VBA Code Explained
VBA

UDF to Fetch Comment Text in Excel Cell: VBA Code Explained

June 24, 2019October 9, 2026 PKComments Off on UDF to Fetch Comment Text in Excel Cell: VBA Code Explained
Need to fetch comment text in an Excel cell so you can filter, count or report on it? Excel has no built-in formula that reads a comment, but a five-line
Read More
UDF for Evaluate a Formula in Excel: Turn Text into Results
VBA

UDF for Evaluate a Formula in Excel: Turn Text into Results

April 18, 2019October 9, 2026 PKComments Off on UDF for Evaluate a Formula in Excel: Turn Text into Results
A UDF for evaluate a formula in Excel solves a common annoyance: a formula stored as text, such as 5+6+7 or VLOOKUP(10005,Sheet2!A:B,2,0), just sits in the cell and never calculates.
Read More
Text Join Formula for All Excel Versions: TEXTJOIN UDF in VBA
VBA

Text Join Formula for All Excel Versions: TEXTJOIN UDF in VBA

May 23, 2018October 9, 2026 PK0
This text join formula for all Excel versions gives you TEXTJOIN-style results even if your Excel does not have the TEXTJOIN function. TEXTJOIN joins a whole range of cells into
Read More
VBA

VLOOKUP by cell background color

May 13, 2018September 2, 2024 PK0
VLOOKUP is a popular function in Microsoft Excel. It helps users to find and retrieve specific data from a large table or range of data. However, there is a limitation
Read More
  • Learn Excel (Free Course)
    • 1. Shortcut Keys
    • 2. Fill & Flash Fill
    • 3. Find & Replace
    • 4. Sort & Filter
    • 5. Formulas & Functions
    • 6. Data Validation
    • 7. Conditional Formatting
    • 8. Basic Charts
    • 9. Advanced Charts
    • 10. Pivot Tables
    • 11. Excel Dashboards
    • 12. VBA Course
    • 13. Excel Formulas with AI
  • Templates
  • Tutorials
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
    • Excel Dashboards
    • Power Pivot & DAX
  • Power BI
  • Template Store
    • Ready to Use Templates
  • Courses
  • Academy
    • Excel + AI Mastery: 100 Formulas
    • Excel Pivot Tables & Dashboards
  • About Us
  • Contact Us
Copyright © 2023 PK-AnExcelExpert.com - Privacy Policy