Breaking a Cell
There is a cell in the excel workbook as A4 . I like to draw a line in
between this cell so that the content of this cell get breaked. i.e. if there is written MICROSOFT than i like to break this as micro and soft but without using the left or right or mid formula. Is this possible....Please advise.. Regards Santosh Budalakoti |
Hi Santosh,
Assuming that you want to retain the text in a single cell, then at the point where you want to insert a line break, type Alt Enter. Alternatively. if it is your intention to split the text into adjacent columns, look at the 'Text to Columns' feature on the Data menu. --- Regards, Norman "Santosh Budalakoti" wrote in message ... There is a cell in the excel workbook as A4 . I like to draw a line in between this cell so that the content of this cell get breaked. i.e. if there is written MICROSOFT than i like to break this as micro and soft but without using the left or right or mid formula. Is this possible....Please advise.. Regards Santosh Budalakoti |
All times are GMT +1. The time now is 06:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com