Text To Row

Text to Row

Text to column is already there, now you might be looking for how to convert text to row,Just copy your list of rows and paste it in MS-Word as text.

·      

       Now press ctrl + H key

·        In find  put comma (,) if you want to remove comma between two names.

·        In replace put ^l (shift + ^ and L)

·        Click on replace all

·        Copy all

·        Paste it in  excel sheet.

Simple ! isn’t it!