Macro to split the contents in a single cell separated by ","into next cell in that column
On Jan 21, 11:29*am, anshu minocha wrote:
Hi,
I have sheet 1:
* * * * column A * *column B *columnC
* * * * WR# * * * * *Phase * * * SP#
Row2 60625 * * * 1-0110 * * * 60625RB1,60625NS1,60625GW1,60625BB1
Expected Output on clicking a button:
* * * * *column A * *column B *columnC
* * * * *WR# * * * * *Phase * * * SP#
Row2 60625 * * * 1-0110 * * * 60625RB1
Row3 * * * * * * * * * * * * * * * * *60625NS1
Row4 * * * * * * * * * * * * * * * * 60625GW1
Row5 * * * * * * * * * * * * * * * * 60625BB1
Is there a way to split the contents in cell C2 separated by comma (,)
and place it on next cell in column C itself?
Please suggest.Thankyou.
|