group multiple values from a single cell which are comma split

[Ananthak275]

have the output in Column A. Want to get COLUMN B and C. How do i do it?

A	B	C
apple: RT, banana: TR, banana: DS, apple:PL	apple: RT,apple:PL	banana: TR, banana: DS

need an excel formula

 

[hrayani]

Try,

=LEFT(B2,SEARCH(",",B2))&" "&C2&", "&MID(B2,SEARCH(",",B2)+1,99)

 

[Ananthak275]

Try,

=LEFT(B2,SEARCH(",",B2))&" "&C2&", "&MID(B2,SEARCH(",",B2)+1,99)

the output is 0 for some reason

 

[hrayani]

it

the output is 0 for some reason

I wonder why - it's working for me

Book3
	A	B	C
1	apple: RT, banana: TR, banana: DS, apple:PL	apple: RT,apple:PL	banana: TR, banana: DS
Sheet3

Cell Formulas
Range	Formula
A1	A1	=LEFT(B1,SEARCH(",",B1))&" "&C1&", "&MID(B1,SEARCH(",",B1)+1,99)

 

[Ananthak275]

it

I wonder why - it's working for me

Book3
	A	B	C
1	apple: RT, banana: TR, banana: DS, apple:PL	apple: RT,apple:PL	banana: TR, banana: DS
Sheet3

Cell Formulas
Range	Formula
A1	A1	=LEFT(B1,SEARCH(",",B1))&" "&C1&", "&MID(B1,SEARCH(",",B1)+1,99)

I think there might be a miscommunication. the output should be column B & C

 

[hrayani]

Ok then try this

Book4
	A	B	C
1	apple: RT, banana: TR, banana: DS, apple:PL	apple: RT, apple:PL	banana: TR, banana: DS
Sheet1

Cell Formulas
Range	Formula
B1	B1	=LEFT(A1,SEARCH(",",A1))&RIGHT(A1,LEN(A1)-SEARCH(",",A1,SEARCH(",",A1,SEARCH(",",A1)+1)+1))
C1	C1	=MID(A1,SEARCH(",",A1)+1,SEARCH(",",A1,SEARCH(",",A1)+1)+1)