Spreading text into multiple rows

  • Thread starter Thread starter xxxBogusemail
  • Start date Start date
X

xxxBogusemail

I am trying to split lengthy text in a cell into multiple rows so that
it is roughly the same length in each row. E.g., I have pasted the
following text from a web page into Excel 97 cell B5:

Information and interactive calculators are made available to you as
self-help tools for your independent use and are not intended to
provide investment advice. We can not and do not guarantee their
applicability or accuracy in regards to your individual circumstances.
All examples are hypothetical and are for illustrative purposes. We
encourage you to seek personalized advice from qualified professionals
regarding all personal finance issues.

I want to split this text in B5 so that segments roughly equal in
length appear in consecutive rows B5 to B14. Desired result:

B5: Information and interactive calculators are made
B6: available to you as self-help tools for your
B7: independent use and are not intended to provide
B8: investment advice. We can not and do not
B9: guarantee their applicability or accuracy in
B10: regards to your individual circumstances. All
B11 examples are hypothetical and are for
B12: illustrative purposes. We encourage you to seek
B13: personalized advice from qualified professionals
B14: regarding all personal finance issues.

Does Excel 97 have a built-in command that will do this? Or, macro
suggestions please.

Thx much.
 
You can use Edit | Fill | Justify to do this, but for some reason it will
only process the first 255 characters of the text.
 
I think you could have a macro do it, but I'm not sure I would.

Once you split your paragraph into different cells, it's gonna be miserable to
change the wording and spacing.

This is one of those rare situations that I'd use (the dreaded) merge cells.

Try this against a test copy of your workbook.

Merge cells can cause a bunch of problems (they've gotten better in each version
since they were introduced into xl97).

But try selecting B5:B14 and then hit the merge cell icon on the formatting
toolbar (or Format|Cells|Alignment tab, check the merge cells box).

Resize the rows the way you want.

To see one of the bad features in xl97, try to delete just row 8.

I don't like them, but sometimes they're necessary.
 
Back
Top