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