Excel Formula

[suman dalal]

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"

[Sisyphus]

Hi,
Use ALT-Enter to enter a line break in a cell.
Have a great day!

[Don]

Even though you can do this within a cell, as Sisyphus mentioned, this can really mess-up the look of your spreadsheet. If it's possible, it really is better to separate the data into columns and rows instead of using in-cell line-breaks. It really just comes down to formatting.