Hi all Can I do a text to columns using {lf} (line feed), Alt+Enter as the separator? Thanks in advance for any help SPL

Trying to concatenate two dates with a "To" between to show a beginning and Ending date. Unfortunately, Excel keeps posting the dates as a serial number. Since...

Hi There, I have a simple excel table, in one of the fields that is called "filled" the answer is either (yes) or (no), I simply want to count how many "yes"...

Hi everyone. You guys are always a lot of help when I start hitting a wall! Hope someone can help me again. I am running XP Pro, SP2, and Office Professional...

Originally, I asked for help with a formula to convert cubic centimeters to fluid ounces and ccs. When the value of centimeters goes over 30 ccs (I know this...

If i have a table with similar names and values next to the name, how can I sum up all of those numbers similar to a vlookup function where i could say "total...

I added the Analysis Toolpak so I could get the =NETWORKDAYS formula. After doing so, it still won't work. Any idea why?

Ok, I am so close to this worksheet being done. Thank you everyone for your help and finally one last question, I hope :) I have everything working the way I...

i only want to copy & paste the subtotals, not the supporting data thanks

I am trying to perform a standard vector LOOKUP on some data I have. The problem I am facing is that my data array contains over 83 thousand lines and Excel...

How do I prevent Excel from automatically converting text that looks like a date into a date. For example, if I type in 5-23 or 5/23, I need to prevent Excel...

Lewis Clark got my formula half-way there this morning. Thanks Lewis! If I had been a bit more precise, I bet he would have told me the rest of what I need to...

I want to be able to have excel determine last years holiday dates by looking at this years date which is entered in a cell. Example: Cell a1 is where a...

This is the most basic question I'm sure but how can I link numerous sub statements into one macro?

I need help with the following calculation. I cannot seem to get my mind around the If function in a way that would help me with creating a conditional 'Due...

In this formula I cannot figure out how to keep "false" from coming up when the statement is false. If it is not "OVERDUE", then I want the cell to show...

Thanks in advance for any help with this... How do I display the result of a "countif" formula in parentheses? What would I add to the following...

I have a list of data that I wish to rank, but I do not want the gaps in the ranking numbers created by duplicates in the data, ie. Data Rank Req 1 ...

Dear all I have created a hyperlink on an Excel worksheet which is liked to another workbook. When a user clicks onto the link and is taken to the other...

=IF(A34.99,A3*6,IF(A39.9,(A3*6.3)+5,IF(A324.99,(A3*6)+15,IF(A349.99,(A3*5.8)+12,IF(A374.99,(A3*5.5)+8,IF(A399.99,(A3*5.25)+8,IF(A3149.99,(A3*5.25)+8)))))...