how i can give line break (to below mention data) after the company name & then add the address in the same cell in seperate lines (making some changes in address eg: "comas")& then how i can copy the formula to the other cells.
"Kansai Nerolac Paint Ltd., Ganpatrao Kadam Marg, Lower Parel,
Mumbai 400 013"
Marubeni - Itochu Steel Inc.
"Marubeni India Pvt. Ltd., 5th Floor, Berjaya House, Community
Centre, New Friends Colony, New Delhi –
110065"
"Matsushita Electric Works Ltd., Flat No. 625-627, 6th Floor, West Block,
Meridien Commercial Tower, New Delhi –
110019"