Alt + enter macro

[boss1982]

hi

test11112222.xlsx

i need ur help plz, i have some cells contains text with alt+enter, i need a macro to split the content of the cell to many cells

thanks

[nilem]

Hi Boss,
try

Please Login or Register  to view this content.

[berlan]

Great solution nilem!!!

[boss1982]

hi, the 2 sheets (before & after is only for example), can u please modify the macro to edit any sheet and in the same sheet.

ur code will do only for sheet before and after...
thanks

[nilem]

in the same sheet

Please Login or Register  to view this content.