Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to put a WORD Doc into Excel
First, please I know this is bad, but my manager has made this requirement. I am trying to take my Word Doc and place it into an Excel Spread sheet. This document has bullets and numbering. What I am running into is cells with ######### all the way across. I have tried to setup WORD WRAP - no luck. I have tried using AUTOFIT for ROW and Column - No luck. I have tried to maximize the cell - no luck. The section of the document I am working with looks like this: €¢ An incident was declared with the Desktop due to abnormal storage errors that caused the system to get recursive OC4 abends. The mean time to resolution was 4hr 12min, resulting in the scheduled maintenance window being exceeded by 2.12 hrs causing us to miss the batch SLA. To date, the following quality improvement was implemented in response to this incident. 1. Tech Support Technicians created a new OPS/MVS non scrollable console message to alert Operations immediately if this error occurs again. This will improve mean time to resolution should this reoccur. But when I place it into a cell (either manually typing it in or paste special using TEXT) it goes to ##### in the cell. Is what I am trying to do possible or are there limits to putting text into a cell? If so, what are the rules (or where do I find them) This is a management thing not mine. I would have left it in word. -- Lizette Koehler |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to put a WORD Doc into Excel
Excel has a problem with text-formatted cells if they contain between 255 and
1024 characters. Changing the format to General seems to be the only way to get rid of the ##########'s Gord Dibben MS Excel MVP On Thu, 5 Jul 2007 10:28:01 -0700, Lizette Koehler wrote: First, please I know this is bad, but my manager has made this requirement. I am trying to take my Word Doc and place it into an Excel Spread sheet. This document has bullets and numbering. What I am running into is cells with ######### all the way across. I have tried to setup WORD WRAP - no luck. I have tried using AUTOFIT for ROW and Column - No luck. I have tried to maximize the cell - no luck. The section of the document I am working with looks like this: • An incident was declared with the Desktop due to abnormal storage errors that caused the system to get recursive OC4 abends. The mean time to resolution was 4hr 12min, resulting in the scheduled maintenance window being exceeded by 2.12 hrs causing us to miss the batch SLA. To date, the following quality improvement was implemented in response to this incident. 1. Tech Support Technicians created a new OPS/MVS non scrollable console message to alert Operations immediately if this error occurs again. This will improve mean time to resolution should this reoccur. But when I place it into a cell (either manually typing it in or paste special using TEXT) it goes to ##### in the cell. Is what I am trying to do possible or are there limits to putting text into a cell? If so, what are the rules (or where do I find them) This is a management thing not mine. I would have left it in word. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to put a WORD Doc into Excel
Thanks, that did help. Now how do I keep the text flowing from the TOP of
the cell rather than the Bottom? -- Lizette Koehler "Gord Dibben" wrote: Excel has a problem with text-formatted cells if they contain between 255 and 1024 characters. Changing the format to General seems to be the only way to get rid of the ##########'s Gord Dibben MS Excel MVP On Thu, 5 Jul 2007 10:28:01 -0700, Lizette Koehler wrote: First, please I know this is bad, but my manager has made this requirement. I am trying to take my Word Doc and place it into an Excel Spread sheet. This document has bullets and numbering. What I am running into is cells with ######### all the way across. I have tried to setup WORD WRAP - no luck. I have tried using AUTOFIT for ROW and Column - No luck. I have tried to maximize the cell - no luck. The section of the document I am working with looks like this: €¢ An incident was declared with the Desktop due to abnormal storage errors that caused the system to get recursive OC4 abends. The mean time to resolution was 4hr 12min, resulting in the scheduled maintenance window being exceeded by 2.12 hrs causing us to miss the batch SLA. To date, the following quality improvement was implemented in response to this incident. 1. Tech Support Technicians created a new OPS/MVS non scrollable console message to alert Operations immediately if this error occurs again. This will improve mean time to resolution should this reoccur. But when I place it into a cell (either manually typing it in or paste special using TEXT) it goes to ##### in the cell. Is what I am trying to do possible or are there limits to putting text into a cell? If so, what are the rules (or where do I find them) This is a management thing not mine. I would have left it in word. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to put a WORD Doc into Excel
FormatCellsAlignmentVerticalTop
Also have "Wrap Text" enabled. Gord On Thu, 5 Jul 2007 12:22:04 -0700, Lizette Koehler wrote: Thanks, that did help. Now how do I keep the text flowing from the TOP of the cell rather than the Bottom? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to put a WORD Doc into Excel
Cell alignment is controlled on the format menu, cells, alignment tab,
vertical alignment. Placing a word document into excel, is problematic for several reasons. Although excel can do very, very basic page formatting, excel is not a word processor. To apply formatting (bold, italic, etc.) to any word, or paragraph will required direct formatting for each and every occurence. It is possible to inadvertently reset the formatting for the entire cell to a single format, and then you are back to square one. I hope the document is pasted onto its own worksheet. At least, then you can set discrete page width, height, and header/footers. Can you convince them to embed /link the spread sheet data into a word document? This is far easier to control the format. If not good luck. Is the word document short? If the document is short, you could paste it into text boxes. This would give you better control of the text. One or more text boxes set to 6 in. by 9 in. would emulate a typed page with 1 in. margins. Unfortunately, text boxes cannot be linked within excel. Tom C ==== "Lizette Koehler" wrote: Thanks, that did help. Now how do I keep the text flowing from the TOP of the cell rather than the Bottom? -- Lizette Koehler "Gord Dibben" wrote: Excel has a problem with text-formatted cells if they contain between 255 and 1024 characters. Changing the format to General seems to be the only way to get rid of the ##########'s Gord Dibben MS Excel MVP On Thu, 5 Jul 2007 10:28:01 -0700, Lizette Koehler wrote: First, please I know this is bad, but my manager has made this requirement. I am trying to take my Word Doc and place it into an Excel Spread sheet. This document has bullets and numbering. What I am running into is cells with ######### all the way across. I have tried to setup WORD WRAP - no luck. I have tried using AUTOFIT for ROW and Column - No luck. I have tried to maximize the cell - no luck. The section of the document I am working with looks like this: €¢ An incident was declared with the Desktop due to abnormal storage errors that caused the system to get recursive OC4 abends. The mean time to resolution was 4hr 12min, resulting in the scheduled maintenance window being exceeded by 2.12 hrs causing us to miss the batch SLA. To date, the following quality improvement was implemented in response to this incident. 1. Tech Support Technicians created a new OPS/MVS non scrollable console message to alert Operations immediately if this error occurs again. This will improve mean time to resolution should this reoccur. But when I place it into a cell (either manually typing it in or paste special using TEXT) it goes to ##### in the cell. Is what I am trying to do possible or are there limits to putting text into a cell? If so, what are the rules (or where do I find them) This is a management thing not mine. I would have left it in word. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to put a WORD Doc into Excel
Hi,
Hi, I would recommend the word document to embedded with the Excel Worksheet. To Embed Word document Do the following: 1. On the Insert menu, click Object. The Object dialog box is displayed. 2, Click the Create from File Tab. 3. Click the Browse button. Then select your .PDF document from your local machine. 4. In the Browse dialog box, click the Insert button to return to the Object dialog box. 5. Click the Link to File and Display as Icon check boxes if you want the document to be displayed as an icon with the path of the document file or just clear the Link to File and Display as Icon check boxes and adjust the corners to to your requirement. Challa Prabhu "Lizette Koehler" wrote: First, please I know this is bad, but my manager has made this requirement. I am trying to take my Word Doc and place it into an Excel Spread sheet. This document has bullets and numbering. What I am running into is cells with ######### all the way across. I have tried to setup WORD WRAP - no luck. I have tried using AUTOFIT for ROW and Column - No luck. I have tried to maximize the cell - no luck. The section of the document I am working with looks like this: €¢ An incident was declared with the Desktop due to abnormal storage errors that caused the system to get recursive OC4 abends. The mean time to resolution was 4hr 12min, resulting in the scheduled maintenance window being exceeded by 2.12 hrs causing us to miss the batch SLA. To date, the following quality improvement was implemented in response to this incident. 1. Tech Support Technicians created a new OPS/MVS non scrollable console message to alert Operations immediately if this error occurs again. This will improve mean time to resolution should this reoccur. But when I place it into a cell (either manually typing it in or paste special using TEXT) it goes to ##### in the cell. Is what I am trying to do possible or are there limits to putting text into a cell? If so, what are the rules (or where do I find them) This is a management thing not mine. I would have left it in word. -- Lizette Koehler |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy from Word to Excel, and retain indent, plus word wrap | Excel Discussion (Misc queries) | |||
Link table from excel to word using word VBA | Excel Discussion (Misc queries) | |||
Excel Hyperlink doesn't open Word doc the same way as Word does | Excel Discussion (Misc queries) | |||
Print labels by using Excel data in a Word mail into word | Excel Discussion (Misc queries) | |||
Embedding Word Docs into Excel Worksheets and Then Printing The Word Docs | Excel Worksheet Functions |