| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
spread out fields in different column
I have one excel spread sheet look like as following:
ColumnA ColumnB ColumnC ColumnD 1 gwp\test1 2 gwp\test2 I need to separate on ColumnB to ColumnC and D so it will be like this ColumnA ColumnB ColumnC ColumnD 1 gwp\test1 gwp test1 2 gwp\test2 gwp test2 I try to use IF condition on C1 but did not work. =IF(ISERR(FIND("\",B1)),B1,LEFT(B1,FIND("\" B1) -1 also on D1 I do like this =Right(B1,LEN(B1),FIND("\" B1,1)) can someone help me? Thanks Lillian LIllian |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
spread out fields in different column
In C1:
=IF(ISERR(FIND("\",B1)),B1,LEFT(B1,FIND("\",B1)-1)) In D1: =IF(ISERR(FIND("\",B1)),B1,RIGHT(B1,LEN(B1)-FIND("\",B1))) Mike F "Lillian Lian" wrote in message ... I have one excel spread sheet look like as following: ColumnA ColumnB ColumnC ColumnD 1 gwp\test1 2 gwp\test2 I need to separate on ColumnB to ColumnC and D so it will be like this ColumnA ColumnB ColumnC ColumnD 1 gwp\test1 gwp test1 2 gwp\test2 gwp test2 I try to use IF condition on C1 but did not work. =IF(ISERR(FIND("\",B1)),B1,LEFT(B1,FIND("\" B1) -1 also on D1 I do like this =Right(B1,LEN(B1),FIND("\" B1,1)) can someone help me? Thanks Lillian LIllian |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
spread out fields in different column
Mike,
It works, thank you so much. Lillian "Mike Fogleman" wrote: In C1: =IF(ISERR(FIND("\",B1)),B1,LEFT(B1,FIND("\",B1)-1)) In D1: =IF(ISERR(FIND("\",B1)),B1,RIGHT(B1,LEN(B1)-FIND("\",B1))) Mike F "Lillian Lian" wrote in message ... I have one excel spread sheet look like as following: ColumnA ColumnB ColumnC ColumnD 1 gwp\test1 2 gwp\test2 I need to separate on ColumnB to ColumnC and D so it will be like this ColumnA ColumnB ColumnC ColumnD 1 gwp\test1 gwp test1 2 gwp\test2 gwp test2 I try to use IF condition on C1 but did not work. =IF(ISERR(FIND("\",B1)),B1,LEFT(B1,FIND("\" B1) -1 also on D1 I do like this =Right(B1,LEN(B1),FIND("\" B1,1)) can someone help me? Thanks Lillian LIllian |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| freeze column and row on same spread sheet | Excel Worksheet Functions | |||
| Can you spread Pivot Table "Value" Fields in seperate columns | Excel Discussion (Misc queries) | |||
| Combining spread sheets with common fields | Excel Discussion (Misc queries) | |||
| Pivot table: showing COLUMN summaries for some, not all, COLUMN fields. | Excel Programming | |||
| I want to change the column width on a spread sheet? | Excel Worksheet Functions | |||
Hybrid Mode
