There is a cell will a 15-character string of text in it. I would like to
return the character at position 7. How do I do this?

hi , i have a list of data where there are blank cell. i need to do a count
for the pivot table but the pivot is unable to count hw many blank data i
have. what can i do to get teh pivot to  coutn my blank data. i do not want
to replace blank with any value. this is what the ...

I am running a basic account program I set up my self. I use this program to
keep track of my monthly expenses, what I spend money on, how much I spend,
to incluld taxes. One collum I keep track of my yearly expenses, the other I
keep track of my monthly expenses.

Is there something you can type into a formula that signifies "anything at
all".
In other words I need to enter a formula that when any number, date, text,
or whatever it may be is typed into A1, then B1=10. Thanks for the help.

Here's another one for those much smarter than me. Cell A10 will have a
static date. If we have reached that date or gone beyond it then I want A20
to equal 10. Any ideas? Thanks for your help.

I am trying to solve this problem and really could use some help. Here is the
questions and the spread sheet information. If you have some helpful ideas
that would be awesome. Brian
cel b3 is the system date and time, cell g5 is the due date cell h5 is paid

Again, working on putting a employee schedule together. How do I set it up so
that when the word "Off" is inputing into the schedule column the total
column (the one next to it) automatically inputs zero?       
Thank you

I am doing an employee schedule and I want it set up so that when I change
the first date on the schedule the other dates automatically update as well.  
How do I do that?
Thank you

Again, putting together employee schedule. How do I set it up so as I input
the schedule day by day if the total hours scheduled exceeds 40 it shows up
red with a message? Is that possible?
Thank you

Does anyone know how I can make the printer setup the same for multiple
sheets in a workbook?
I have thirty one (31) sheets I would like to print the exact same way.
I have tried to group all the sheets but it will not allow me to set the

Is there a way to unprotect a group rather than having to unprotect each
sheet individually?

Is it possible to name a group of sheets so that if I call up the group it
will regroup the sheets and after I ungroup them I can group them again with
just a couple of keystrokes rather than select each sheet again.

Have a report with the following data
     Insurance Patient Name Claim #
     EINSURANCE CO. A 123
     EINSURANCE CO. A 234

Need help on solving a problem, I have A1 to G1 as (Sun thru Sat) for Days
off with pay, A2 to G2 where I put hours; then A3 to G3 is for regular hours;
then A4 to G4 is overtime hours, I have the regular hours ( A3 to G3 ) set up
perfect to work with overtime hours ( A4 to G4), ...

For a pivot report, with the pages setup to each year, how can I
customize show pages command to append additional new pivot reports to
the current worksheet instead of creating new ones?
Additionally is there anyway to lay out each report on a different