Kindly mention yours email ID for the sample file.

I have bank account in 4 banks and at present I am printing my cheques
through Excel on a laser printer.

The Find function (Ctrl-F) won't locate occurences of the "~"
character. Is there some way I can search for that character?

I have an Excel (2007) sheet with three columns. All are formatted as
text. In some rows, the third column contains several hundred
characters. Those cells display as ################, but if I select
that cell, the display window above shoes the actual data and if I

We have an Excel 2007 worksheet with 44 sheets. Each sheet executes a query
against a view in Sql Server 2000.  The user has to enter the password 44
times, once for each sheet!  She is going crazy!  Is there a way for the
sheets to share one connection, or at least share the ...

Hey there.
I'm working with two sheets on a file. On the first sheet is a list of
students and the schools that they attend, with the student in column
A and the school in B. There are 200 rows. In sheet2, there is a list

I am not sure if or how to use all three in a formula. For example:
=if(b2="red", and c3="blue", d6="green")
if that makes sense at all.

I have a large Excel 2007 file containing text data that includes most
of the special characters on the keyboard. I need to create a
delimited text file without any processing of the data. That is, no
adding quotes or what have you.

Although my personal macro workbook (Personal.xlsb) is saved to my XLStart
folder (In Microsoft Windows XP, this workbook is saved in the C:\Documents
and Settings\user name\Application Data\Microsoft\Excel\XLStart folder).
The personal macro workbook does not open automatically ...

I have Excel 2007 SP2. When I try to copy a formula using Ctrl+C and
paste using Ctrl+V, only the copied value (i.e., not the calculated
value using the formula) is pasted. When I copy using Ctrl+C and paste
using a right mouse click, it pastes correctly. Also, if I copy using

The thing that I am wondering the most is how to start a macros.  Adding on
to that question where is the tools menu to start the macros?  This version
of Office is completely different from the others.

I need to add the total in cell H6 if the following condition is met
If H6<>0 and A6 contains the word "total" (where A6 can contain alph
and numbers) i.e. the formula must only find the total if a6 contain
the word "total" and not if it simpy contains other figures or alpha

i have 3 different open issues lists on 3 tabs of a workbook that i want to
summarize the priority items onto one list on another tab. i want to tick off
items in priority order by a,b,c etc. and collect them in sorted priority
order all on one tab. does anyone have any ideas how ...

I hope you can help.  I want to copy a worksheet from one book to the
workbook that is already open.
Example - open closed book called Owner Rep and copy the single sheet in
that book called sheet1 to the open book and replace existing sheet1.

I have five numbers in:
A1,B1,C1,D1,E1
Is there a function that will give me the linear regression of those
numbers that can be put in D1, with charting etc?

Any way to format 'comment' transparency (default = opaque) ?