Saturday, January 7, 2012

in excel, my cell shows 56 avenue 4 belgium 5673820.. i wan the country onwards to separate down in same cell


in excel, my cell shows 56 avenue 4 belgium 5673820.. i wan the country onwards to separate down in same cell?
like this 56 avenue 4 belgium 5673820 it doesnt work when i press enter... can it be done??? when i copy and paste from other source its done automatically
Software - 2 Answers
Random Answers, Critics, Comments, Opinions :
1 :
you can have this result by doing a right-click on the cell, choose format cell, click alignment and check wrap text. just be sure that the width of the column will be enoudh to make the country and the numbers after it to go down. This is just a temporary solution.
2 :
Try Alt+Enter, plus format the cell for wrapping.