[Lizette Koehler]

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

[Gord Dibben]

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.

[Lizette Koehler]

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.

[Gord Dibben]

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?

[Tom Conrad]

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.

[challa prabhu]

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