cut to first space in excel code example

Example 1: cut to first space in excel

RIGHT(A2,LEN(A2)-FIND("@",SUBSTITUTE(A2,"/","@",LEN(A2)-LEN(SUBSTITUTE(A2,"/",""))),1))

Example 2: cut to first space in excel

=RIGHT(B2,FIND(" ",B2)-1) for rtl "LEFT" for ltr