Remove Special Characters from Text String with Excel LAMBDA Function - Excel Data Cleaning - No VBA

Learn how to remove special characters from Excel data in a text string using Excel 365's latest LAMBDA function. With LAMBDA function we can write special purpose functions that can help in removing special characters from the data.

In this tutorial, we learn how to make a custom function using Excel LAMBDA. Based on recursive LAMBDA method, we made a simple formula to extract text from cells containing mixed data riddled with special characters.

Using this formula, we can easily remove special characters from the text data. No need to write complex and lengthy VBA code to get this job done!

Lets Excel!

Access or download practice workbook file for this Excel 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 #exceltips #exceltricks #exceltutorial #exceltutorialforbeginners #excelformula #excelfunctions #excelformulasandfunctions #excelformulatypes #excellmabda #lambda #recursivelambda #exceldata #exceldataentry #exceldataentrywork #exceldatacleanup

[farooqtahir]

Really this is the right way? would we get award for using this complex and long formula.We are living in A.l era where work is supposed to be done instantly and right.

[snapcracknpot]

Is there a way to do this same thing but for different text with characters within a list. ex: (Happy) (Sad) (Big) (Tall)? Helpful video btw, thank you.

[ashishedutech]

which area select after then you goto name define box tell me

[sb]

Useful video but you should have atleast explain us that it would have become more easier for us to apply the formula.

[dinelli]

In what cases we using? Thanks thanks...

[leomason]

Cool to see and nice to know that this is possible but this one would be nice with a little more explanation.

For example, are all special characters manually listed or was there a formula used?

Had no idea this was possible.

[paulofigueroa]

can you do short video about removing special characters in full name, for example it mike*"#han"opol then it will turn into mike hanopol

[ferndoggydogg]

Seems a little very long “shortcut” with no explanation