MABE Work Order Create use:
Brand add excel formula: =IF(LEFT(G2,1)="Z", "GE Monogram","GE")
Customer name spilt formula:
First name: =LEFT(N2,SEARCH(" ",N2,1))
Last name: =RIGHT(N2,LEN(N2)-SEARCH(" ",N2,1))