ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Splitting cell contents (https://www.excelbanter.com/excel-discussion-misc-queries/164795-splitting-cell-contents.html)

GARY

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.


Gary''s Student

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.




All times are GMT +1. The time now is 04:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com