E
ernietan
hello..
I have a column of data which i want to split into 2 other columns.
For example,
A B C
ABC SCH, CDE SCH ABC SCH CDE SCH
FGH SCH, FGH SCH -
IJK SCH, LMN SCH IJK SCH LMN SCH
As seen above, the data is separated by commas.
I have input this formuale into cell B1 : =LEFT(A1,FIND(",",A1)-1) and I
manage to get the "ABC SCH".
But I don't know what formuale to put in cell C1.
Can anyone help me ?
Thanks!
I have a column of data which i want to split into 2 other columns.
For example,
A B C
ABC SCH, CDE SCH ABC SCH CDE SCH
FGH SCH, FGH SCH -
IJK SCH, LMN SCH IJK SCH LMN SCH
As seen above, the data is separated by commas.
I have input this formuale into cell B1 : =LEFT(A1,FIND(",",A1)-1) and I
manage to get the "ABC SCH".
But I don't know what formuale to put in cell C1.
Can anyone help me ?
Thanks!