Problem trying to Wrap text within Microsoft Excel.?
463346
are your rows/columns large enough to accommodate your font size?
268106
Copy, paste special, check the transpose box in the dialog box \n\nCheers\n\nDaz
912638
One solution is to cut and paste images into the header of the document and move the image to the desired location and then close header.\n\nAnother solution would be to use tables and place the image and text inside the cells.  You should then be able to use 'format picture'.
417607
I don't know if this is exactly what you need, but it sounds like you are getting an error when you compile macros in VBA because of a bad reference.\n\nTake a look at the reference dialog box on the VBA Tools menu.  There may be something there that you need to check off.  These kinds of links sometimes get lost when you change versions of Excel.
714464
join the cells (cell merge) so it spans two columns.\n\n<td colspan='2'>
1105719
In Excel, functions and macros only can do this. Try the functions PROPER, UPPER and LOWER.\n\nCtrl+Shift+A is another Word keystroke for changing case, it doesn't work in Excel.\n\nCheck out:\nhttp://www.mvps.org/dmcritchie/excel/proper.htm#upper
348716
Can't do that in Excel. The best thing you can do is type your headings in row 1 in each column.
700134
There are a lot of templates from microsoft.com under office templates.  There should be some for Excel and Word.
488375
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
1080679
Try selecting all of the text you wish to reformat, pressing the right mouse button over the selected text and then select format.  That's how I would do it on a PC, it's probably something similar on a MAC.
991056
This can be done in MS Words using Fields:\n\nhttp://word.mvps.org/FAQs/Numbering/PageNumbering.htm\n\nbut I have never been able to do this in Excel. I have tried just about any character or word inside the brackets that I could come up with, but no luck. \n\nA couple of times when I thought I absolutely needed the numbering, I pasted my charts and data into a Word document.\n\nIt wasn't perfect, but with some tweaking it was at least presentable.
769661
the expression is being cut off.\nPlease break the expression over multiple lines, \nand I'll try to help
347042
I just looked up the Add On.  It looks very good.  I know what might be your problem.\n\n(1)  Click on the cell to edit the formula.  \n(2)  Press Ctrl-Shift-Enter\n\nStep 2 will insert the {} which you need for an array function.  If this does not help not sure what the problem is without seeing the entire formula.
163668
I would suggest using a plain text editor, such as notepad (win), textedit (mac), or an open-source plain text editor.
275571
sure you downloaded for the correct version of office you are using? Also, copying it to C: might make a difference perhaps.
857302
If this is an excel file, go to the page set-up it has an adjust to: %, if this is say at 45% then the text/numbers will come out very small. Adjust it to a higher number to get it the text/numbers to come out larger.
230306
What hurricane is describing is using a string qualifier.\n\nFor example (in this example, replace the . with a tab):\n\n'Text column 1'. '04323221'. 'Hello'\n'Blah blah blah'. '34332321'. 'Paris'\n'Random ol&#92;' text'. '9223221'. 'Green'\n\nNotice that each field begins and ends with a single-quote. The idea is that by qualifying each field with single-quotes, Excel will import the contents as a string.\n\nThat sounds great on paper and should work in theory, but it won't, because anytime Excel sees all digits, it wants a number, even if you use qualifiers.\n\nYou have to manually set up the import in Excel to work properly, if you want those zeros saved.\n\nTo do that:\n\n1. Open Excel\n2. Use File --> Open to open your TSV file\n3. Set the Files of type drop-down to be All Files, navigate to where your TSV is saved, and open it.\n4. In the dialog box, choose Delimeted, skip any rows that need skipping, choose the right encoding and click Next\n5. Make sure Tab is chosen in the delimeters and, if you have opted to use a text qualifier, it is selected.\n6. Click Next\n7. For columns that will contain leading zeros, click on that column, then choose text for the Column data format from the radio buttons at top right.\n8. Click Finish.