software

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!


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 quot;SHOWquot;
paragraph marks to be able to see what is actually happening. The
quot;paragraph markquot; symbol is locate one of the quot;VIEW - TOOLBARS -
STANDARD.quot;
If you need to get rid of some quot;extraquot; 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: www.excelforum.com/member.php...oamp;userid=29640
View this thread: www.excelforum.com/showthread...hreadid=511440