I have data in cell A1, I need to separate as CELL B1 & CELL C1
A1= TG-1 ICDH0096      CELL B1= TG-1    CELL C1=DH0096
Below two formula working fine , I need one more logic , if cell A1 having blank the results for CELL B1 also remain blank ,& likewise CELL C1 also.
B1=TRIM(LEFT(A1,FIND(" ",A1)))
C1= IF(ISNUMBER(SEARCH("TG",A1)),RIGHT(A1,7),A1)