Breaking a Cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use & with two formulas 2
Excel Concatenate with line breaks but ignore blank cells 3
Excel 2007 Page Break Adjustments causes a page break each cell 1
Line Break Vlookup 2
Conditional Page Break 7
If function across sheets prints value of cell 4
Transfer data from a cell to another workbook if certain criteria 14
coditional Page Break 3

Back
Top