Select Page

## How to Unpivot Data with New Excel Functions

Unpivoting data is a common task when working with spreadsheets, as it involves transforming data from a wide format to a long format, making it easier to analyze and visualize. With the introduction of new functions in Excel, the process of unpivoting data has become...

## Handling Macro Enabled Excel Files in SpreadsheetWeb – Converting VBA-based UDFs to LAMBDA functions

Incorporating VBA-based UDFs (User-Defined Functions) in Excel empowers users to extend the functionality of their spreadsheets beyond the standard set of available functions. By leveraging VBA (Visual Basic for Applications), a versatile programming language native...

## How to calculate as-the-crow-flies distance between two cities in Excel

You might think "as the crow flies" distance is nothing more than a simple hypotenuse calculation back from geometry class. Unfortunately, not. You should work with either decimal degrees or degree-minute-second (DMS) notation due to the curvy structure of Earth. This...

## A Use Case of Excel's LAMBDA Function in SpreadsheetWeb: Splitting Text by delimiter with LAMBDA Function

SpreadsheetWeb Hub supports Excel's LAMBDA function. The recently released LAMBDA function allows Excel users to build custom, reusable functions without VBA. There are so many use cases of the LAMBDA function. In this article, we will create a LAMBDA Function to...

## A Use Case of Excel's LAMBDA Function in SpreadsheetWeb: Calculating Distance by Latitude and Longitude

SpreadsheetWeb Hub supports Excel's LAMBDA function. Recently released LAMBDA function allows Excel users to build custom, reusable functions without VBA. There are so many use cases of LAMBDA function. In this article, we will build a function to calculate distance...

## How to get filename from path in Excel

In this guide, we’re going to show you how to get filename from path in Excel. We will cover how to do this with and without VBA. Download Workbook File path and file name A file path is a string identifier that specifies the unique location in a file system. It...

## How to slugify a string with Excel

“Slugify” is a term for converting strings into URL slug format. A URL slug, or just slug in this article’s context, is the part of the URL that comes after the domain extension. In this guide, we’re going to show you how to slugify a string with Excel. Download...

## How to reverse a text string in Excel

In this guide, we’re going to show you how to reverse a text string in Excel. Download Workbook Please note that as of we are writing this article, functions like TEXTJOIN and CONCAT are available for Excel 2019 and Microsoft 365 subscribers only. Syntax CONCAT...

## How to create recursive functions in Excel with LAMBDA

Recursive function is a term for describing behavior of a function that calls itself from within its own code. This is necessary for solving a problem where the solution relies on the results from multiple instances of the same problem. In this guide, we’re...