I have data in cell A1, I need to separate as CELL B1 & CELL C1
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.![]()
A1= TG-1 ICDH0096 CELL B1= TG-1 CELL C1=DH0096
![]()
B1=TRIM(LEFT(A1,FIND(" ",A1))) C1= IF(ISNUMBER(SEARCH("TG",A1)),RIGHT(A1,7),A1)
Bookmarks