| Subject | Date Asked |
|
| excel -vba- text file | 10/3/2008 |
Q: 1) i have table down loaded from sap.in to excel. but i get hypen like this ...
A: For people that are familiar with Excel, this would not be a problem. Once you open the file in ...
|
| Extract text from a cell | 8/4/2008 |
Q: Problem: I have a cell in which the data will be as follows (please copy into a notepad): xxxxxxxx ...
A: The formula to get the date would be , ...
|
| Problem in aplying vlookup formula | 4/1/2008 |
Q: I am having problem while using vlookup command in Excel. I have data base on one year. I am look ...
A: Please ensure that the table_array is sorted and the table_array rows are not in the same rows as ...
|
| Counting problem | 1/2/2008 |
Q: I would be much appreciated if you could help to advise me the formula to solve my problem. I need ...
A: You would need to use the formula like =dsum(). It would be a lengthy procedure to explain the usage ...
|
| Sumif Help Request | 12/1/2007 |
Q: i kindly need your help in the following: i have a sumif formula as ...
A: Please try using the absolute addressing ($) to fix the cells that you would want to include in the ...
|
| how to sort rows with formulas | 3/1/2007 |
Q: I have a difficult issue that I am trying to resolve and since I am new at excel2003 I cannot find ...
A: You can first copy the cells that you wish to and then use the following sequence of commands to ...
|
| Textfile saved from Excel | 5/1/2006 |
Q: Whenever I want to use a textfile created by doing a saveas on an Excel worksheet, I can't access ...
A: You can never have two different programs accessing a file that has the same filename. In your ...
|
| Make 1 field into many columns | 11/15/2005 |
Q: I have a single field with values like - 123,456,789 and would like to have them converted to single ...
A: You could use the Data->Text to Columns options. Select the column that you wish to convert into ...
|
| If/or formula | 2/1/2005 |
Q: I want to set up a formula that looks at 5 or 6 cells (in the same row, although not next to each ...
A: You could use this function in the cell, where you did like to put the result ...
|
| Macros | 11/30/2004 |
Q: How do I "enable" an existing macro? Thanks! P.S. We're using EXCEL 2000.
A: If you want to execute an existing macro, you could goto to Tools->Macros->Execute to run an ...
|
| modify a list | 4/30/2004 |
Q: I have a list of emails in excel and would like to have a comma afer each one. How can I do that to ...
A: I assume that each email is contained in a row in a single column. Insert a blank column next to the ...
|
| formulas | 3/1/2004 |
Q: I am using Excel 2000 and cannot figure out the following formula: I want to type a part number ...
A: Suppose you have the data in worksheet2. Name it as Db and sort it on the first column which ...
|
