TEXT.SELECT -My Custom Excel Function

I would like to talk to you about one of my favorite Excel Functions that I created with the help of LAMBDA

If you always need to separate/extract  the components of a cell so that you can use each part separately, then I think this formula will be useful for you.

http://text.select/
This formula allows the user to select a specific piece of text from a cell (in the same way as the http://text.select/ in PowerQuery).

It consists of 4 main parts
 
 =http://text.select/ ( MixedText ,    Select   , Space   , Keep)

➡MIXEDTEXT :   Select the Cell

➡SELECT :
Type  1  for Numbers
Type  2 f or English  Letters
Type  3   for Uppercase English  Letters
Type  4   for Lowercase English  Letters
Type  5   for Other Languages (Some languages are still not supported)

 
➡SPACE :

 Type 1 to Keep the Space
 Skip this part if you want to ignore the space

➡Keep :

In this part , if you want to keep Non-alphanumeric type them like this {".";"@";"-"} between Quotations and separated by the semicolon.

 If you want to ignore this part , then type ""

Example #1:

in this example I am showing how to extract :Number, All Letters , Uppercase Letters , Lowercase Letters and any other language if found

Example #2:

How to Extract emails with all its components like  [ @ , . , - , _ ] 

Example #3:

How to Extract emails and any text in different (and as I mentioned Some languages are still not supported) carefully notice that ,It is possible to find a space between sentences, and it is also possible not to find one. So, TEXT.SELECT handles this easily..

WHAT DO YOU THINK ? IS IT USEFUL ? WOULD IT SAVE TIME?

https://www.linkedin.com/feed/hashtag/?keywords=hazem_hassan&highlightedUpdateUrns=urn%3Ali%3Aactivity%3A7157295034118070272 https://www.linkedin.com/feed/hashtag/?keywords=dr_excel&highlightedUpdateUrns=urn%3Ali%3Aactivity%3A7157295034118070272 https://www.linkedin.com/feed/hashtag/?keywords=excel&highlightedUpdateUrns=urn%3Ali%3Aactivity%3A7157295034118070272 https://www.linkedin.com/feed/hashtag/?keywords=excelskills&highlightedUpdateUrns=urn%3Ali%3Aactivity%3A7157295034118070272 https://www.linkedin.com/feed/hashtag/?keywords=exceltricks&highlightedUpdateUrns=urn%3Ali%3Aactivity%3A7157295034118070272 https://www.linkedin.com/feed/hashtag/?keywords=exceltips&highlightedUpdateUrns=urn%3Ali%3Aactivity%3A7157295034118070272 https://www.linkedin.com/feed/hashtag/?keywords=mvp&highlightedUpdateUrns=urn%3Ali%3Aactivity%3A7157295034118070272 https://www.linkedin.com/feed/hashtag/?keywords=mvpdevelopment&highlightedUpdateUrns=urn%3Ali%3Aactivity%3A7157295034118070272 https://www.linkedin.com/feed/hashtag/?keywords=mvpbuzz&highlightedUpdateUrns=urn%3Ali%3Aactivity%3A7157295034118070272 https://www.linkedin.com/feed/hashtag/?keywords=mvps&highlightedUpdateUrns=urn%3Ali%3Aactivity%3A7157295034118070272 https://www.linkedin.com/feed/hashtag/?keywords=microsoftambassador&highlightedUpdateUrns=urn%3Ali%3Aactivity%3A7157295034118070272