Excel Pro Trick: Automate Tasks in Excel with Recursive LAMBDA Function in Excel Formula - No VBA

Learn how to make a custom function to automate the find and replace task in Excel using Recursive LAMBDA function in Excel formula. No need of VBA coding as LAMBDA function help us avoid complex formulas and codes!

In this Excel tutorial we learn to harness the power of LAMBDA function by creating a custom function using recursive LAMBDA facility with which we can repeat a process to run in a loop until the task at hand is accomplished.

In today's example, we have abbreviated names that we want to replace with full names from the list. A tedious task if done manually, but with XREPLACE custom function using LAMBDA, we can easily automate the bulk find and replace operation in seconds!

Lets Excel!

Excel Workbook to Download or Practice online for this tutorial:

For more Excel tips, tricks and tutorials don't forget to subscribe to @LearnExceltoexcel channel.

Learn #Excel your way:
===================
--------------------------------------

Pick your favourite social page:

#excel #excelformul #excelfunction #excelfunctions #excelformulasandfunctions #excelformulatypes #excelformulaforjobinterview #excellambda #lambda #lambdafunction #lambdaformula #findandreplace #replace

[udayallada]

It will be very helpful if you could explain while doing it.

[willm]

It’s a substitute function (the intials are being replaced by the full names )
He is using a recursive lambda, so that after the values have been changed, it loops through to the next chill to check for another change of initials, once it has looped through the names list next item to change is zero and the loop ends

[oladayoadebiyi]

Try and explain now. You'll complicate the whole thing and play that background music that doesn't help. I guess the purpose for posting this is for enlightenment, but I'm in darkness.

[fatashanadia]

IF(abb= ??, name, XREPLACE(

what the ????

[MGAa]

This is no help for an average user nor it is sufficient to use that for small task like this - as an example where you connect large datasets ok maybe …