Excel LAMBDA can start with a simple custom text function. @thefpandaguy
Excel LAMBDA can start with a simple custom text function.  @thefpandaguy
Uploaded October 2026 | Updated November 2026, 1 day ago
In this episode of Financial Modeler’s Corner Podcast, host Paul Barnhurst welcomes Diarmuid Early, alongside co-hosts Giles Male and Ian Schnoor, to explore how simple LAMBDA functions can make the concept more approachable.

Extreme single-cell solutions can make LAMBDA look intimidating to anyone used to traditional models.

A formula taking 57 steps can feel like a cliff edge, but it isn’t the starting point you need.

The core idea is to turn a series of Excel steps into a custom function that performs the same task.

That task can be something simple and familiar.

Excel has TEXTBEFORE and TEXTAFTER functions, while a custom “text between” function illustrates another possibility.

The example credited to Alan Murray shows a concept that several people have approached similarly.

The entry point to LAMBDA can be a small task you already understand.

🎧 Listen to the full episode on @thefpandaguy

#Excel #LAMBDA #ExcelFunctions #CustomFunctions #ExcelTips #FinancialModeling #FPandA #SpreadsheetModeling #ExcelFormulas #LearnExcel
Excel LAMBDA can start with a simple custom text function.AI Finance Club: What Three Members Learned from the Experience with Eve, Jurgen & BukieOne prompt should never replace judgment.How to Choose Finance Software Without Waiting for AI to Settle with Glenn HopperStop using Excel the slow way.Succession planning defines real leadership strength.Excel interview questions can reveal more than spreadsheet skills.The future pays for impact.Real builders skip design partners.Excel people have the best team names.The safest career is continuous learning.Want to move up? Create solutions.
The FP&A Guy |

Excel LAMBDA can start with a simple custom text function.

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER