How to get filename from path in Excel

How to get filename from path in Excel

by | Jun 23, 2021 | Excel Tips & Tricks

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...
Function: LAMBDA

Function: LAMBDA

by | Jan 22, 2021 | Excel Formulas

LAMBDA is a special function that can create custom functions in the scope of a named range. You can essentially create a user defined function without any VBA, macro, or JavaScript knowledge. In this guide, we’re going to show you how to use the LAMBDA function and...

How to create User Defined Functions (UDF) in SpreadsheetWEB

by | Feb 10, 2016 | Tutorial

What is a User Defined Function (UDF)? A user-defined function (UDF) is a function provided by the user of a program or environment, in a context where the usual assumption is that functions are built into the program or environment. Although Microsoft Office Excel...
What's New in Version 4.7

What's New in Version 4.7

by | Jan 7, 2016 | Blog

SpreadsheetWEB allows users to create a user interface (UI) directly from their workbook. While this is a very powerful feature and requires no programming experience, you are limited to a user interface that mirrors the look and feel of...