• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Make text separate in below required cells from one cell.

Hi Ramesh..

In E2.. use formula as..

Code: 
=MID(TRIM(MID(SUBSTITUTE($F$2,CHAR(10),REPT(" ",LEN($F$2))),((ROWS(A$2:A2)-1)*LEN($F$2))+1,LEN($F$2))),3,255)
 
Debraj said:
Hi Ramesh..

In E2.. use formula as..

Code: 
=MID(TRIM(MID(SUBSTITUTE($F$2,CHAR(10),REPT(" ",LEN($F$2))),((ROWS(A$2:A2)-1)*LEN($F$2))+1,LEN($F$2))),3,255)
Click to expand...

Outstanding @Dev sir!
Thanks for this help!!
Thanks & Regards
Ramesh Deo
 
Last edited by a moderator:
You must log in or register to reply here.
Back
Top