Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! If possible, maybe a VBA code for everything here? (I'm don't know anything about VBA at all) -- help me |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
data splitting
On Apr 20, 10:18*am, ernietan
wrote: I have a column of data which i want to split into 2 other columns. ... But I don't know what formuale to put in cell C1. Try the mid function, something like [=mid(A1,FIND(",",A1)+1,999)] - I think you have to specify an upper limit for the length which I have put as 999 here. If there might not be a comma, you need an if around it to check the find. Phil Hibbs. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
data splitting
Try
=TRIM(MID(A1,FIND(",",A1)+1,255)) OR try 'Text to Columns' option from menu 'Data' -- Jacob (MVP - Excel) "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! If possible, maybe a VBA code for everything here? (I'm don't know anything about VBA at all) -- help me |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
data splitting
....or if you don't want to specify the arbitrary length limit, you
could do it this way: =RIGHT(A1,LEN(A1)-FIND(",",A1)) Phil Hibbs. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
data splitting
alright! thanks! it works wonder..
-- help me "Jacob Skaria" wrote: Try =TRIM(MID(A1,FIND(",",A1)+1,255)) OR try 'Text to Columns' option from menu 'Data' -- Jacob (MVP - Excel) "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! If possible, maybe a VBA code for everything here? (I'm don't know anything about VBA at all) -- help me |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data splitting | Excel Discussion (Misc queries) | |||
Splitting data into seperate worksheets with data change | Excel Programming | |||
Splitting data from one sheet into 2 other sheets. Data is skewed | Excel Programming | |||
Splitting Data | Excel Worksheet Functions | |||
Please Help Splitting data | Excel Programming |