Uncategorized

Excel: Find patterns on Text

 

 

=TRIM(RIGHT(SUBSTITUTE(LEFT(B2,FIND (” “,B2&” “,FIND(“@”,B2))-1),” “, REPT(” “,LEN(B2))),LEN(B2))).

=LEFT(B2,FIND (” “,B2&” “,FIND(“@”,B2))-1

Attachments:

Leave a Reply

Your email address will not be published. Required fields are marked *