New line in a cell (Alt + Enter)

[Revathi kannan]

Hi all,

Need your assistance to solve the below.

> I have data in column C wherein i need to split the data in the same cell with the reference "**" wherever this ** appears in column C then I should split the data using Alt + Enter in the same cell.

> My attached file consists of my data in column C and desired output in column D.

Thanks.

[jindon]

1) Select Column C, Hit Ctrl + H
2) Enter search string ~*~*, click on Replace string box and enter 0010 from number pad with holding down Ctrl key.

VBA

Please Login or Register  to view this content.

[Revathi kannan]

Thanks a lot Jindon.. It works perfectly. I was looking for this past 2 hrs.