Extract Special Characters - 2 Methods: LAMBDA Function with Recursion or VBA User Defined Function
Download the featured file here: https://www.bluepecantraining.com/wp-...
The main aim of this video is to introduce the idea of recursion within the new LAMBDA function in Excel 365. Recursion is the ability to loop - for a function to refer to itself.
Alan Turing hypothesized that there would one day be a machine that could solve any problem. Excel is now "Turing complete" as it can solve any computational problem (according to Microsoft) with LAMBDA's recursive capabilities.
Here is a good article on this subject: https://techcommunity.microsoft.com/t...
I compare the LAMBDA function with a VBA user-defined function which is capable of exactly the same thing. I get both functions to remove special and numeric characters from my data.
Here’s a copy of the UDF code featured in the video.
Function CLEANDATAVBA(ddata As String, uchars As String)
Do Until uchars = ""
ddata = Replace(ddata, Left(uchars, 1), "")
uchars = Right(uchars, Len(uchars) - 1)
Loop
CLEANDATAVBA = ddata
End Function
Auf dieser Seite können Sie das Online-Video Extract Special Characters - 2 Methods: LAMBDA Function with Recursion or VBA User Defined Function mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Chester Tugwell 11 Februar 2021 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 2,785 Mal angesehen und es wurde von 86 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
