Prev: excel 2007
Next: Invoice created from Excel ocr Access and sent via Outlook
From: ernietan on 20 Apr 2010 05:28
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
From: Jacob Skaria on 20 Apr 2010 05:40
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
 | 
Pages: 1
Prev: excel 2007
Next: Invoice created from Excel ocr Access and sent via Outlook