Formatting text in Excel
 

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!

Formatting text in Excel
 

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.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=511440