Can you create a formula to spit a cells contents.
EX. in A1  = W3056
I would like A3= 30
       and A4 = 56

I have a cell that references B2 i need the reference to stay at B2 even if
i insert a row at row 2. Currently the reference moves to B3. Is there any
way around this?

I have cells that contain data in this format:
ANIMALS-PETS-DOGS-BROWN
ANIMALS-PETSFARM-DOGS-BEAGLES
ANIMALS-PET-CATS-TABBY

I have a spreadsheet which lists users and has some info about the user.
Example of the field names:
name state gradelevel
I need something that will basically say "if state=NJ and gradelevel=12" add

I use this formula to sum the values in every fourth cell in colums
=SUMPRODUCT((MOD(ROW(E7:E190),4)=3)*(E7:E190)). This works in about half of
the colums, but returns the error #DIV/0! in the other colums. I do not get
why I get the error only some of the time.

I have a number coming otu in decimal form representing days
.25, .5, 1.25 1.5, 100.5, 368.75, it can be anything up to about 3 years.
I need to convert to Dayss:Hrs:minutes   ddd:hh:mm
so 1.5 would be 1:12:00

Excel vlookup function returns #VALUE when the lookup value exceeds 256
characters.  I need a hash function to transform large strings into a value
that does not exceed the 256 character limit.  Are there any quick solutions
to this problem?

A little bit tricky this one, I have 2 columns of data that I want t
apply a conditional formatting to.  The conditions are that BOTH cell
in any given row of the data be > .05 or both be >.04
If both cells are greater than .04 each and also less than .05 eac

Is there any way to automatically alphabetize worksheets? I can do it
manually by click and dragging, but not automatically. thanks.

All,
I'm sure that this is easily found but I'm not sure what to search for.
I have a formula that i want to persist throughout the worksheet. The figures I want to always have calculated are in a header row in this case row 2:
1000 - 2000 - 3000 - etc.

if i type the number 3 in cell b1, how can I get that value copied into cell
c3?
and then when i type in cell b2, to have that value copied into cell c3
which will overwrite the previous number copied?

My data comes in like this:
Type    ID    Group
B    BOX017    VR
A    BOX017    S1

Need a formula to serve a simple/complex function.
NEED IT TO PERFORM A -=COUNTIF- TO MAKE SURE THE VALUES IN
CLOUMN A MATCH CERTAIN CRITERIA. IF THEY MATCH THE CRITERIA
THAN I WOULD LIKE FOR IT TO SEARCH ANOTHER COLUMN IN THE SAME ROW

Is there any function in Excel to identify duplicate records

How can I automatically have a named range populate?  Example:  In column 1,
I have a list of 6 employees named "employees".  I added another employee.  
How can I get my named range "employees" to include the new employee.