I need to import a text file of data where the delimiter between fields is a carriage return. -- Gordo T

I have a very simple macro that, when run, takes the user to a specified location on another sheet in the same workbook: Sub ToProjectInfoPage() ...

I'm trying to change times that are reported in text format (ie 0830PM instead of 8:30PM) into military time equivalents. Is there a straightforward way to...

I want to add the date to a spreadsheet where it will change every day that I open it up. Is this possible and if so how. PLEASE HELP

I have written the following formula =SUMIF(B5:B21,"partner",D5:D21) but would like to include an OR criteria =SUMIF(B5:B21,OR("partner","manager"),D5:D21)...

A DOCUMENT WITH THE NAME \"BOOK1.XLS\" IS ALREADY OPENED. YOU CANNOT OPEN TWO DOCUMENTS WITH THE SAME NAME, EVEN IF THE DOCUMENT ARE IN DIFFERENT FOLDERS. TO...

Hello, i have a problem with excel field formatting. The data is in text format, but i need it to be in time format. When i select a field and select time as...

I'm working with some raw data exported to Excel from some tracking software we use. For each of our agents (call center), there are between 1-5 entries. In...

I need a formula to deal with the following problem. If ORDERS are 4 or more AND MONTHLY CUMULATIVE is greater than or equal to 750000 then everything up to...

Okay, so here is my dilema. In a column, I have numbers like 123456789 and 234567890 (all are 9 digits long). However, when you select the cell, you can see...

I have a spread sheet with some check boxes on it but one of the check boxes can only be seen when we print the sheet. There is no VB code on the sheet or...

A spreadsheet worked correctly for months but suddenly stopped calculating. The function is =SUM(C2:O2) and is copied down for all the rows. Cells are...

Dear Excel experts, Sometimes when I copy cells from one Excel to the next the formulas get's lost. I select some cells contain some formulas and press copy...

i have in column A:A a various list of dates in the following format 12/08/2006 Saturday I want to create a list of the available months in column A:A to...

:) My dear friends & respected ones, warm regards to everybody. I am new to this forum. My query is :Is there any operator or function in MS Excel to...

I have a spreadsheet that always opens to a cell in Column DX. I thought Excel would reopen afile to the cell that was last saved. How can I have the...

I found the neat little edate function in one of the forum answers, which is exactly what I need. However, my formula: =edate(A1,3) does not...

Sorry the title isnt better. My wife walks and house sits dogs and we are trying to set up excel so she can invoice easily. I have created a drop down list of...

Hi, I am trying to work out how to use if and count if to count the number of cells with a certain number in, but only if a cell in an adjacent coloumn has...

I need to often match up columns on two spreadsheets. One of the xls has a reference number of 12 digits...the other has 10 digit. The 10 digits are the...