spread out fields in different column

L

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
 
M

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
 
L

Lillian Lian

Mike,

It works, thank you so much.


Lillian

Mike Fogleman said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top