ExcelBanter - data splitting

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - data splitting (https://www.excelbanter.com/excel-discussion-misc-queries/261920-data-splitting.html)

ernietan

data splitting

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!

--
help me

Jacob Skaria

data splitting

Check out your other post

"ernietan" wrote:

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!

--
help me

All times are GMT +1. The time now is 09:17 PM.