Formatting text in Excel

[jezzica85]

Hi all, does anyone know if it's possible to take a string of text, say from
a page in Microsoft Word, and then paste it into a column in Excel so there's
a word in every cell, that is the alignment changes from horizontal to
vertical? If anyone could help me that would be great! Thanks!

[wjohnson]

In your Word Document do a Find and Replace:
Work with a copy and not the original.
In the FIND box enter the following: ^w
The ^ symbol in the Number 6 key, this will find 'ALL WHITE SPACE,' which is any space entered by the space bar.
In the REPLACE box - enter ^p
This will will put a paragraph return after each word (i.e. puts 1 word to a line). Now do a select ALL and Copy and then paste into EXCEL. Excel will interput - each paragraph mark as a cell.
MAKE SURE that the ^w and ^p are entered as lower case - otherwise the find and replace will not work. You might have to select "SHOW" paragraph marks to be able to see what is actually happening. The "paragraph mark" symbol is locate one of the "VIEW - TOOLBARS - STANDARD."
If you need to get rid of some "extra" blank paragraph marks - in the FIND - enter ^p^p and then in replace enter ^p, this will find 2 and replace with one.