anything in Excel...

It's Excel-o-lozy...

Trick - Opening a file of which u dont know full name.

To open a file of which u dont know full name, use following trick:
Suppose the file name is "All apples are red.xls" and u don kno the full name. Now in following conditions u can still open the file from Excel. Press Ctrl+O and type as follows and press enter and excel window will list all files matching following criteria:
  • If u kno that file name contains "Apple" in between name then:
    - type "*apple*" i.e. start and end word with a star
  • If u kno that file name starts with "All" then:
    - type "All*" i.e. end the word with a star
  • If u kno that file name ends with "Red" then:
    - type "*Red" i.e. start the word with a star
  • and last, if u know that file ends with word "Red" but there is one more letter at end then:
    - type "*Red?" i.e. start the word with star and end with question mark.

Now u kno that wild chracters can be used to apply conditions as follows:

  • * - Star - means unknown no. of characters
  • ? - Question Mark - means one unknown character.

Note : Above trick not only applies to Excel bt all softwares.

0 comments: