Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import text to Excel | Excel Discussion (Misc queries) | |||
How do I stop Excel auto formatting the text 3-4 as 04 Apr? | Excel Discussion (Misc queries) | |||
Conditional Formatting in Excel Help Please..... | Excel Discussion (Misc queries) | |||
Auto Formatting an Excel Spreadsheet | Excel Discussion (Misc queries) |