I can easily wrap text within Microsoft Excel (2002)  - BUT -  when I then add borders – increase row height etc the text no longer wraps?? And no matter if I reformat the cells to wrap text the text will not wrap – can anyone offer any clues as to why this is please.
209540
are your rows/columns large enough to accommodate your font size?
643479
I have found this to be an intermittent glitch in the program. Not sure what or why. Most of the time, it works fine. Every now and then, after creating a new excel document, I run into this problem.\n\nMy get around on this is to take an existing .xls document that cooperates and modify then save. Make sure to rename the file as to not overwrite the original.
446433
If have the same problem importanting my data.\nIn fact there are two problems, one is the separation between data columns, the other is the fact that in American notation for dates and numbers is different from the European one.\n\nIf you open a csv file  OpenOffice shows you a Text Import window.\nFirst you change the Separator options. In my case the Comma field is set, so I change it to semi-colon ; as my data are separated like that, but it might be that space or tab is the correct choice for your data.\n\nNow you have your data in correct columns.\n\nGo to the Fields lower on the pages. Each column is labelled Standard. Right clicking on the word Standard gives you various other options including several ones for the date, as well as the difference between American and European number format.\n\nIf you don't get OpenOffice to understand you, there is no other choice than to change the input file by hand or macro first.\n\nPS If a date does not contain the year, OpenOffice *always* assumes it is the present year. Therefore you have to change the date columns either by including the year explicitly, or in OpenOffice after import.\n\nPS2 I have everything automated with macros. After all it is an exercise one has to repeat often.
359822
Wellll, the only thing I can think of is if you're using Word, open the Formatting Toolbar (View>Toolbars>Formatting) and look over the alignment buttons, is every line on your business card aligned as you want them (left, center, right)?  Or, is there any problem with the size of the type or the typeface?
74577
Sometimes width attribute does not work properly due to the contents of some other cell in the same row or column. So, try including the <td> alone within a <table> with width atrtribute to <table> tag
462540
********************************************\n\nI have Office 2000, so these instructions may or may not be the same for your version.\nThe easiest way for me is to first know how many rows and columns I need. Then I right click and hold the button down while moving the mouse over the rows and columns I want included in the table. For example: If i want a table that is 4 columns wide, I would select A through D. Then, while still holding the right click down, I select the rows that I want. If I want 10 rows down, I select 1 through 10. After they are all selected in blue, I release the right button on the mouse. The rows and columns selected should remain highlighted.\n\nNext at the top of the page there should be a grid of squares button to select. If there isn't, you can find the little arrows button to find more buttons. It will be in there. Click it or the little arrow pointing down beside it for more selections. This will give you a grid and different types of line thicknesses.\n\nIf you can't find it this way, then after highlighting the areas you want included, right click again in the middle of a highlighted square and another window will open. Click 'Format Cells' in the box that opens. Next click the 'Border' tab. Then choose the formatting you want. You can do this more than once to get more than one effect on your table.\n\nIf none of this is what you want to do, then go to Microsoft Templates at this link: http://office.microsoft.com/en-us/templates/default.aspx\nThere are as many templates there as there are hours that you have to look through them. You can do a search for the specific type of table you want. After you download the template (these are small files) you can customize it how you want it after you open it.\n\nHope this helps. Good luck.\n\n****************************************************
223331
All that usually means is that you have entered a number value, and the column width is too small for Excel to display it.\nIncrease the column width and the spreadsheet will display your numerical value properly.
387749
well, im not sure. but try one of these--\n\n < style type="text/css" >td td embed, object, pram, embed{height:0; width:0}< /style >\n\nOR \n\n< style type="text/css" >td td embed, object, pram, embed{height:0; width:0}< /style >\n\nalso.. get rid of the spaces in between < style   and " >   etc. or it realllyyy won't work.  :) goodluck.
486593
To get all the text to fit, you will need to resize the font.  \nTo change all the templates at the same time, you can choose to apply to all when u figure out the size of the font
397620
this code works for me: \n\n<style> table table td.text table td.text table table tbody td table, span.btext {display: none !important} </style>\n\nput it anywhere in ur "about me" section, this code is sooooooooo hard to find, took me forever!!!
59332
if the cell is specifically formatted to be "text", then that can happen.  Go to "Format", "Cell", then change the format to "General"\n\nI just went to Excel and check it, and "text" format caused the problem and putting it to "general" and retyping the equation fixed the problem.
570389
Since this is coming from the database and it's a very long word entered by a user you probably won't be able to "wrap" it in the element.\n\nIf you set widths for the element, IE will expand the element and firefox will have the text overlap the element.\n\nYou could truncate the word or phrase returned to a number of characters either when you pull it from the database or when you display it on the page.\n\nIn MS SQL it's\nLEFT ( character_expression , integer_expression ) \n\nso \nLEFT (columName, 15)\n\nwould give you 15 characters of the contents within ColumnName\n\n(You could also limit the entry of the column to 15 characters)\n\nOR you can use your scripting language to do the same thing.\n\nthen use an if statement to see if the characters in columnName value is more than 15 characters.  some pseudo code here:\n\nif characters in columName > 15 {\n   output '...';\n}\n\nso you get\n\nThisIsVeryLongW...\n\nIf your long words are in the middle of a phrase and you can't truncate the whole phrase, it's going to be more difficult to make it fit.  You might want to consider changing the design.\n\n-------------\nedit\n------------\n\nIn CSS3, there is word-wrap:break-word which might help but I'm not sure of the support\n\nThere is also the tag <wbr> and & shy; which might help as well if you can calculate where to put them.
442474
Use conditional formatting\n\nhttp://www.contextures.com/xlCondFormat01.html
35054
Naveed Zafar Sheikh is right in that you need to use a fixed width. Words get wrapped at the fixed number of pixels specified. There is one caveat, if the browser window is made smaller, the wrap will compress for each <TD> to the pixel size of the longest word...\n\nSo for example, the following table:\n\n<table cellpadding="1" cellspacing="1">\n<tr>\n<td width="50">This is text that should wrap since this is longer than 50 pixels.</td>\n<td width="100">This is text that should wrap since this is longer than 100 pixels.</td>\n<td width="500">This is text that should not wrap since this is probably shorter than 500 pixels.</td>\n</tr>\n</table>\n\nlooks as expected when the browser window width is greater than 650 pixels. As the width decreases, so does the width of each column evetually looking something like this in the extreem case:\n\nThis is This is This is\ntest    text    text that\nthat    that    should\nshould  should  not wrap\nwrap    wrap    since this\nsince   since   is\nthis is this is probably\nlonger  longer  shorter\nthan    than    than 500\n50      100     pixels.\npixels. pixels.
222770
Hi Casp911\n\nI have not seen the formula spaces anywhere.... the formula is REPT.. .so, taking the example of Dragon Dave\n\nH6&Rept(30-LEN(H6))\nthe question here is if you are exporting the info from Excel or importing directly from the other program... if the other program is a microsoft one, you can solve your problem using a simple macro\n\nlet me know if i can be of further help
587648
Try and put a border on the table so that you can see better what you are doing wrong. Just set the table border=1 and then you can visualize how your table is handling the columns wrong. You probably just misplaced a tag or you forgot to close a row or column and its looking funky.\n\nI honestly cant tell you whats wrong with it unless I see the actual html code page.
269762
In general, one of the best Excel answer sites I have found is MrExcel.com (link below).  But in any case, the better you state your problem the better the advice you'll get.\n\nFor example, how many pages do your reports run?  What do you hope to gain by converting them from Excel to Word?  Are you aware of other solutions, such as 'printing' your report to a PDF file?  (CutePDF, for one example)  Finally, is this something that could be handled by MailMerge (if you know what that is)?  If you don't understand MailMerge, you can look it up in Word's help.