I have been supplied a huge Excel file, but all the text has been entered as
CAPS. Is there anyway in Excel that you can change this to Upper and
Lowercase or just lowercase would do.
I am using Excel 2000 on an XP PC.

I have a text box that I want to be equal to a cell. I posted a similar
problem yetsreday about colors in two objects, but now I need the syntax for
textboxes. Here is what I have so far:
ActiveSheet.Shapes("Text1").Selection.Characters.Text =

I am stumped so I am hoping the experts can help.  I have spent many
hours trying to write code to accomplish a certain task and no matter
how I tweak it I keep running into problems.  I will attempt to
explain my goal:

I am putting together a school directory. We have permission from the parents
to print and share the info for student and parent nonbusiness use only.  I
have never done this before.  Are there any programs.  I have Office XP.  Not
sure how to proceed.  Any suggestions??

I am entering text into a cell and I want it to go on to the line within the
cell.
However if I press return it goes to the cell below. Does anyone know how to
make it move on to the next line

I have values in two columns and I want the sum of the product of them. The
problem is: the values in column A are in a non-sequential disposal, as the
sample below:
               A        B        C        D

I am using an Excel spreadsheet for payroll. I input the times and
Excel calculates hours worked. Here's my problem. When I open the
workbook each week it inputs the dates automatically. When I am done it
saves the dates correctly. My problem is when I open an old payroll

I am working on a spreadsheet and when you "look" at the cell it looks like
this:
'S000000200BX00000001000 . I need to figure out how to do an auto sum on
these. I was messing around and did a few find and replace and got rid of the

I have two types of values in a column. One that contains a value with a dot
(GB2-E0031.02) and one that does not contain a value with a dot (GB2-E0031) I
would like to delete the whole row If the value in column B does not contain
a dot (.)

I want to search for the word "Hello" in columns which can consist of
"Hello;Hi;Greetings" and want the hello must based on several
conditions. Now I use this formula, but then I can´t find the cells
which contains more text than just "Hello":

I am stumped so I am hoping the experts can help.  I have spent many
hours trying to write code to accomplish a certain task and no matter
how I tweak it I keep running into problems.  I will attempt to
explain my goal:

Hello all.  Maybe someone will know how to help me with this.  I am
trying to make a simple menu for our cafeteria to put on our school web
page.  Everything looks great, but when I add some images (not all of
them do this) it distorts the gridlines.  Some have spaces, and some

need to record payments/money spent on college expenses...

How do I create a new function in Excel?

Hi friends,
Is there any way to count how many blocks of data are there on a sheet.
You can call it as tables or blocks. If there are many tables (Data
blocks) are there on a single sheet is there any way to get a count of