Split single cell to multiple rows

Hi,


I'm trying to write a VBA and place it in an excel sheet so that VBA gets triggered on opening excel.
Curently what I have is:

Please Login or Register  to view this content.

What I am looking for is:

Please Login or Register  to view this content.

In result, the values of the third column are in different rows

Hi Jet
It's preferred to attach a sample of the desired results
Generally try this code (suppose your headers in row 1 and the target column is C)

Please Login or Register  to view this content.