spread out fields in different column

[Lillian Lian]

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

 

[Mike Fogleman]

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]

Mike,

It works, thank you so much.


Lillian

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