Thread: Macro to split the contents in a single cell separated by "," intonext cell in that column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
anshu minocha anshu minocha is offline
external usenet poster
  
Posts: 23
Default Macro to split the contents in a single cell separated by "," intonext cell in that column
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.



Reply With QuoteReply With Quote