Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 117
Default Splitting cell contents

A cell contains multiple phrases and sentences which makes the cell
extremely long.

For example:

And so, my fellow americans: ask not what your country can do for you
- ask what you can do for your country. My fellow citizens of the
world: ask not what America will do for you, but what together we can
do for the freedom of man.


Other than using "Wrap Text", how can I make each phrase or sentence
start at the left edge of the cell?

For example:

And so,
my fellow americans:
ask not what your country can do for you
ask what you can do for your country.
My fellow citizens of the world:
ask not what America will do for you,
but what together we can do for the freedom of man.

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default Splitting cell contents

You can leave the wrapping on. Locate the point in the text that you want to
break and insert an ALT-ENTER at each point.
--
Gary''s Student - gsnu2007a


"GARY" wrote:

A cell contains multiple phrases and sentences which makes the cell
extremely long.

For example:

And so, my fellow americans: ask not what your country can do for you
- ask what you can do for your country. My fellow citizens of the
world: ask not what America will do for you, but what together we can
do for the freedom of man.


Other than using "Wrap Text", how can I make each phrase or sentence
start at the left edge of the cell?

For example:

And so,
my fellow americans:
ask not what your country can do for you
ask what you can do for your country.
My fellow citizens of the world:
ask not what America will do for you,
but what together we can do for the freedom of man.


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
Trouble splitting cell contents scottr Excel Discussion (Misc queries) 2 April 17th 07 03:33 PM
Splitting the contents of a cell Keith Excel Discussion (Misc queries) 7 September 21st 06 07:21 PM
Splitting the contents of a cell? Dan B Excel Worksheet Functions 4 December 8th 05 08:34 PM
Splitting Cell Contents with a comma Dejan Excel Worksheet Functions 1 October 6th 05 09:14 PM
Splitting multiple cell contents containing values at end Syns Excel Worksheet Functions 2 May 24th 05 04:24 PM


All times are GMT +1. The time now is 05:35 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"