Of course, if you want to extract the name of words,
Von wlong12, 01:22 is to use the "= LEFT (the source data grid, extract the number of characters)" function. Still have a kind of conditions, we do not start from both ends, but around among directly from the data extracted several characters. For example we want to extract from the A5 cell "
be required in the target cell type "= MID (A5, 4,2)" on it. Means: A5 cell in the first four characters extracted after two characters, also is the fourth and fifth two words.
Many friends armoured Windows system after always spend a lot of time in Office in setting good personal menus, toolbars, but also create many macros. If these individuals can be Office setting import, export should be much easier. Office 2010 is my favorite.
Actually, Office 2003 cabin have "Microsoft Office 2003 user Settings preservation wizard", can enter derivation in the computer version of personalized menu, toolbars, macro command etc Office personalized Settings.
The specific methods of derived as follows:
First, click on the "start menu -" Microsoft Office "menu -" Microsoft Office tools menu - "Microsoft Office 2003 user Settings preservation wizard", open the "Microsoft Office 2003 user Settings preservation wizard" dialog box.
Second, click the dialog "next" button, "Microsoft Office 2003 user Settings preservation wizard Outlook 2010 is powerful.
would search for computer version of personalized Settings. Search after completion, choose "save the machine Settings", click "next" button, save Office personalized Settings, finally click "finish" button will Office 2003 preferences derived. Microsoft Office is helpful.
Third, when need to import Office personalized Settings, just opened them again "Microsoft Office 2003 user Settings preservation wizard dialog box, select" the original save Settings restore applied to the unit ", according to the above hint import can.
Word is our most commonly used Word processing tools, commonly used for text and form Office 2007 can make life more better and easier.
processing, actually this is only the most basic use of the Word, actually we can play point, using the Word to decorate the covers a desktop, bring additional kind breath! Microsoft outlook 2010 is convenient!
30
