Part of the reason our suggestions don't work is we were responding to your
first post where you said you were putting the text in a single cell. Now
you say you are putting the text in "cells".

What you've found out is why Microsoft developed two programs. Excel excels
at numbers, Word is for text.

Regards,
Fred.

"dgold82" wrote in message
...
Thanks, but really neither of your two suggestions work. I am trying to
paste
a large word document within a worksheet and would like it in cells for
various reasons.

Center across selection allows me to fit the text across my worksheet
without having to merge the cells BUT the text is centered. I would merge
the
cells but wrapping the text doesn't work with over 1,024 charachters and
there are other problems.

I have searched everywhere and it seems that other people are having this
problem as well with some macro solutions that work with wrapping the text
(but not for over 1,024 charachters). Thought there might be another
solution
out there. Right now I am putting my paragraph headers in individual cells
and pasting the body text in text boxes. Looks fine, but is not efficient.

"Fred Smith" wrote:

I'm not sure what you would expect "center across selection" to do other
than center the text.

If you want to justify the text, then choose Justify as your Horizontal
Text
Alignment. You might also want to select Wrap Text.

Regards,
Fred.

"dgold82" wrote in message
...
I have been trying to paste a large amount of text within a cell without
merging cells. I can only find the ability to center across selection
which
works great except that the text is centered. I want to justify the
text
instead, but I can't figure it out.

Help would be appreciated.