It is my understanding that documents open in the view they were saved in - the view is saved with the doc. I may be wrong, since I've been using Word 2000 for a while now, but I believe 97 worked that way as well.
My guess is that it is not a Word problem, but a Windows problem. There is a counter that appears on the status line (bottom of screen) when a document is being queued to print. If it counts to 84, but printing stops after 8 pages, there is a problem in how Windows is communicating with the...
If you really want to break the text into pieces, using LEFT and MID (as repete suggests) will work, but gets a bit clumsy to manage if you want to split it in more than 2 pieces - that is, for a very long string, split into 20 per cell until it's all used up???
Is splitting it into separate...
The answers may differ depending on why you are trying to do this? And in particular, what type of data are you working with? I would expect from the description that it is text, but if it is (big) numbers, the answer changes dramatically. Can you give more info?
You haven't said if you are starting a new doc via File...New Document or the taskbar button. Assuming you're using the File menu (since the New button always results in a default blank document), you say the wizards are 'in system'. You need to check the path to File Locations in the Options...
One simple answer is that the TRIM function should strip off extra spaces.
However, your explanation of the problem is a bit puzzling. You say the data are 'numbers' yet LEFT(A1,9) only extracts 4 digits. This would only be true if the data were a string with 5 leading blanks. But if that were...
Unless I misundertand the question, sounds like the HLookup function will do what you want (for dates). I won't go through all the details here since you can search the Excel Help for HLookup and it will explain exactly how to set it up.
Need some clarification: <br> This only happens on this ONE machine? Only SOMEtimes?<br> Is it always the SAME folder, or any folder with Word files?<br> Is it always the SAME file, or does it happen with different Word files?
I don't think it's renaming the file. When you open the file, Word97 creates a working version as a temp file in the same folder. That will remain there until you close the file - then it will be automatically deleted. However, the original file should still be there (though it will probably be...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.