hi all,
i copy a set of data and paste in excel. after i paste, i realise that only
paste to a single row which is row 1. how to make it to become multiple row
records? the data is seperated by a ';'.

example: only 1 row of record. it continuous in a single row only
panasonic property company ; defino private limited ; luwenor company limit
; ....

how to make it to become
panasonic property company ; defino private limited ;
luwenor company limited ; xesering company limited ;
testory company limited ; forento company limited ;