Excel cell content into multiple rows into another sheet -

Excel cell content into multiple rows into another sheet -

i have requirement in excel want re-create each text ends pulistop row of sheet. ex:

setting configuration.

creating environment.

pushing tasks.

now assume above text in 1 cell , want re-create each sentence ends pulistop individual rows of new sheet. below.

setting configuration.

creating environment.

pushing tasks.

please help me in doing have many no. of sheets needs modification.

thanks in advance. chakri.

check if can useful you:

copy cell(s) clipboard (ctrl+c). paste notepad or similar text editor. note: in notepad lines appear next each other, nevermind, line jumps still there. replace in text editor " (double quotes) nothing. copy whole text of editor. paste excel.

this works in case. if have many cells next each other, method can process @ 1 time same effort. work you?

excel