try also
in c1 drag down
Formula:
=TRIM(RIGHT(SUBSTITUTE(B1,",",REPT(" ",LEN(B1))),LEN(B1)))
and in d1
Formula:
=TRIM(LEFT(RIGHT(SUBSTITUTE(B1,",",REPT(" ",100)),200),100))
try also
in c1 drag down
Formula:
=TRIM(RIGHT(SUBSTITUTE(B1,",",REPT(" ",LEN(B1))),LEN(B1)))
and in d1
Formula:
=TRIM(LEFT(RIGHT(SUBSTITUTE(B1,",",REPT(" ",100)),200),100))
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks