Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
KrunoCro
 
Posts: n/a
Default How to split too long text in one row to break in next row.

In privious Excel versions I use to do it by selecting text and next row and
simply choose Justify from Format menu?
  #2   Report Post  
Gary''s Student
 
Posts: n/a
Default

Either format the cell with wrap turned on or manually insert breaks with
ALT-enter where you want breaks
--
Gary''s Student


"KrunoCro" wrote:

In privious Excel versions I use to do it by selecting text and next row and
simply choose Justify from Format menu?

  #3   Report Post  
KrunoCro
 
Posts: n/a
Default

Hi Gary's Student!
Thanks for trying to answer my question. This is not what I am looking for.
I know about wrapping but this is to make split in same cell/row. I want to
really split too long text which is in one cell/row passing right margin to
below cell/row. Like to cut and paste in below cell/row. To avoid cut and
paste in previous version you suppose to select the cell, extend highlights
to right and row below + chose Justify command from Format menu. I don't know
what happened with that command in latest version, it is not any more stand
as alone command, and it is integrated in Format/Cells/Alignment command?
Anyway thanks,
Kruno.

"Gary''s Student" wrote:

Either format the cell with wrap turned on or manually insert breaks with
ALT-enter where you want breaks
--
Gary''s Student


"KrunoCro" wrote:

In privious Excel versions I use to do it by selecting text and next row and
simply choose Justify from Format menu?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you convert numbers as "text" to values for a long column . geoexcel Excel Discussion (Misc queries) 2 February 27th 05 04:31 PM
Sort or Filter option? Mcobra41 Excel Worksheet Functions 3 February 23rd 05 07:22 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM
How do I split a column having numbers and text in a random order rana8689 Excel Worksheet Functions 2 December 17th 04 09:14 PM
Filter long Text strings Cimorene Excel Worksheet Functions 0 December 1st 04 04:01 AM


All times are GMT +1. The time now is 09:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"