how can i fix this

When recording the results from my practice (cross country running), I have:
Column A: The date when the course was run.
Column B: The name of the course I ran (there are about 10 different courses
that I usually run).

I have a column that displays a person's lastname,firstname.
How can I separate it, so that one column is just the last name, and another
is the firstname.

I currently have a birthday field displayed as 19891011. I would like this to
be displayed as 10/11/1989. How do I do this?

How can i pass variables to my querystring. Here my situation: from inputbox
i keep the value into a variable. i want to use this variable in where
statement.

I am trying to use excel for my reports - using template - certain columns
contains variable length text - which i need to wrap - for print out the cell
row height should get adjusted using text wrap alignment with fixed column
width - how to do that? thanks

We have lots of workbooks with multiple (over 100) spreadsheets.  Is there a
quick way to sort them alphabetically by sheet name?
I tried to right click on one of the sheets, and there was no option to
sort.

Is there any way to safely protect your Excel files (file, sheets and VBA
project) against comercial password crackers?
Someone has a solution?
Thanks!

I can't get the cell to return the result of the formula.
Any suggestions?

How do I calculate how many working days between two
dates. Using the UK holiday calender, I have a list of
additional holiday dates that are non working for the
company. I have named this list as "leaves". I can not

I have been  trying to solve this formula for some time but with no success.
Cell E7 contains Time for end of previous activity, e.g. 14:00
Cell F7 contains Time for start of next activity, e.g. 11:00
=IF(OR((ISTEXT(E7)),(ISBLANK(E7))),F7+TIME(7,0,0),(IF(F7<MOD(E7+TIME(12,0,0)

I am using Excel 2003 and have a master workbook that has many
references (links) to various other workbooks that are in Excel 4.0
format. These source files are created from a query each month.
Depending on the time of the year the source workbook may not exist

Hi, I'm using the sumproduct function to extract data from a large data file
that was imported.
Works great, except for when I run the my macro to import the file all the
sumproduct functions display #REF!

Hello you experts out there.
I nned some Pivot table advice ( a website address for
basics would be great), for instance how to excplain
pivots and how to create them.  

How do I change the code below to look this range up on a sheet called  "
Title "
Private Sub UserForm_Initialize()
   UserForm1.Caption = Range("A1")