I have data of multiple line in an excel cell, Separated by "Enter" (ASCII 13).
By using VBA I want to trasfer each line in to separate excel row.
e.g. Cell B2 contains data --
VS6_AIO > 0 OR VS6_DIOE > 0
VS6_QTY_B = VS6_AIO*2 IF VS6_AIO > 0 AND VS6_REDY = '2',
VS6_QTY_B = VS6_AIO IF VS6_AIO > 0 AND VS6_REDY NE '2',
VS6_QTY_B = VS6_FM IF VS6_FM > 0,
VS6_QTY_B = VS6_FM*2 IF VS6_FM > 0 AND VS6_RPSI>'Y'
I want to saparte it into row C2,C3,C4,C5,C6
Thanks in advance.
-Sachin
