Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Word Problem
Most probably the document page setup is "letter page" whereas the printer's default page setup is A4. You should change your document's page setup to A4.- kraptaki
- Post #3
- Forum: Microsoft: Office
-
How do you use dynamic worksheet names in Excel
This is how I would do it: 1. Write down on a column, all the names of the worksheets you want to retrieve values from. Example: Col A Col B 1 sheetA 2 sheetB 3 sheetC . . . . In another column, for example M, write in cell M1...- kraptaki
- Post #7
- Forum: Microsoft: Office
-
Extracting Digits in a Series of Numbers
If your number is in cell B1 (e.g. 12-152452-456) write this formula in cell a1 and copy it downwards: =MID(B1,FIND("-",B1,1)+1,FIND("-",B1,1+FIND("-",B1,1))-FIND("-",B1,1)-1) Hope this will help!- kraptaki
- Post #8
- Forum: Microsoft: Office
