I thought this would be simple, but it has defeated me. Assume that cells in column A are used to capture a future due date. In column B, I need a formula...

How do I program a cell to have let say a maximum word/sentence length of 50 spaces.:Bgr -- willemeulen Blink1 *Willem van der Meulen* BSc Soil & Water Eng...

Hi, I've just got office 2007 and decided to play around on it to see what it can do. I can't see what I've done wrong for this formula though. in theroy,...

I have tried to make this work in a cell but I must be doing something wrong... I tried different ways shown below... what am I doing...

How I use functios whit "paste special? Meaning: I have data A1 and 1 use some function A2, after that I have to delete colum A1. So A2 get #REF!, how I have...

I wish to somehow combine these two functions so that if "Ford" for instance appears six times in column 'B' then the SUMIF part then returns the sum of the...

In A1 is "-115" B1 is "-15" --- C1 is "-18" --- D1 is "Week 4" E1 is "Price" F1 is "-65" --- G1 is "-25" --- H1 is "256" I1 is "-27"

I am trying to figure out how to add all dollars amounts in other worksheet under same team ID...for instance, there are 100 different team ID but there are...

Hello: I have a formula to calculate the Min value of a range that has includes zero values, which the min formula ignors the zero valus. However, it is an...

I am using a google document survey to have users enter times in a military format. The result is pasted into excel as a "General" format number, like 2253...

Hi, I have 9 members working on a project and require to track the timings for all. There are 6 columns in the spreadsheet. column 1 contains the type of...

What I am working with is a simple divide statment using two worksheets. =('Product'!P20/'Product'!P21) If the answer comes out to zero I get the #DIV/0!, is...

Hi TWIMC, Usually when referencing into a different workbook, Excel constructs the formula like so: =VLOOKUP(B10;'C:\folder path\My...

Dear Expert, How to split a cell into 3 parts if they are like this please ? Befo 9j36 in one cell After: 9 j 36 in 3 different cells Befo 10°32 in...

Hello All: I asked already this question in not a clear manner, so I got unclear answers. So I would like to ask again my question. I hope someone will...

I have to send a daily E-Mail which entails copying and pasting from Excel to Outlook. Is it possible to reduce the font size in the transition from one to...

Am using Excel to keep a record of hours worked by 9 people who perform a variety different tasks daily. The start time and end time are entered in hh.mm...

Hi, I have a code in worksheet_selectionchange that doesn’t seem to work. I intend to do vlookup in column W to Y based on changes column B & C (if column A...

How I can change date format. My problem is following: I use other program where I can export excel-file. This program use USA format (like 05/25/2009), but...

Is there any way to expand a selected column width to fill the screen automatically by macro or Tab event, and if there is will it expand to fit any size...