|
|
Wildcards in If Statement by
Stevkev
It's driving me bonkers. I need to retrieve a true value if the text in a cell contains the word "Rows" plus an * wildcard in an If statement. I am at a loss...
|
|
2 |
419 |
|
|
counting characters by
KK
Hello,
I have a spreadsheet with cells containing strings of characters. eg DWDE
or WWN or ENWEE etc. Strings are not necessarily the same length but are...
|
|
6 |
515 |
|
|
|
|
0 |
317 |
|
|
|
April 30th, 2004 12:56 PM
by mistush
|
1 |
738 |
|
|
F4 key by
light
I use the F4 key alot to repeat actions. But when I copy and paste,then
go to a new area and paste using the F4 key it only does it once. I
then have to use...
|
|
2 |
376 |
|
|
Exit button. by
Orf Bartrop
I want to put a button on a worksheet that closes Excel. I have worked
out how to create the button and attach a macro to it but not how to
create a macro that...
|
|
1 |
385 |
|
|
Problem with scrolling a worksheet by
SOSK
I have created and coded text-boxes ( using the design view and VB-code) in excel that enables me to jump from one text-box to anoter by using the Tab-button,...
|
April 30th, 2004 02:21 PM
by SOSK
|
2 |
392 |
|
|
new, old, difference by
chinonyc
This is most likely a very basic question, since I am a relatively low
level excel user.
Three columns:
New Old Difference
a a ...
|
|
2 |
412 |
|
|
Calculating Time by
Steve
Hi
I'm trying to do a basic workshift for adding up my timesheets for work. I
work 07:00 to 14:00 on the morning shift, 14:00 to 21:00 on the afternoon
shift...
|
April 30th, 2004 05:39 PM
by DDM
|
1 |
396 |
|
|
|
April 30th, 2004 11:21 PM
by esoller
|
0 |
736 |
|
|
Cell format. by
Kim-Anh Tran
How do I format cell allowing only number entry and give message for
retry?
Thanks in advance for your help!
---
Message posted from...
|
|
2 |
418 |
|
|
Name a Column by
DaveB
Is it possible to put a name in place of the "A" at the top of the column? How do I do it?
|
|
5 |
467 |
|
|
modify macro - Help please!! by
rpw
Hi everyone,
I'm VBA dumb so please bear with me. I have a macro that inserts a row at the selection and then I want it to copy the cell below the selection...
|
May 1st, 2004 12:26 AM
by rpw
|
6 |
386 |
|
|
what's the formula? by
DaveB
I have an excel sheet with seven suppliers at the top. In the firsts column are products that I use, and under each of the seven suppliers are that particular...
|
May 1st, 2004 01:31 AM
by rpw
|
4 |
404 |
|
|
|
|
1 |
702 |
|
|
eliminating returns in a field by
ckenney
A have a rather large spreadsheet and in a number of cells
there are "returns" in the cell. Is there a way to
eliminate these "returns"?
"returns" = someone...
|
|
1 |
469 |
|
|
Auto creating rows by
Orf Bartrop
I am trying to construct a worksheet that needs to copy the formulae in
the current row. If I do this manually by pulling down the right bottom
handle my...
|
|
2 |
477 |
|
|
Excel protection by
Fitness Fiend
Hi,
I'm trying to protect a sheet but let users put info into some cells.
I have tried "tools, protection, allow users..." stuff to select the cells I
want...
|
|
2 |
338 |
|
|
entering fractions as text by
Jim
How do I enter a fraction as text, and make it appear as
a fraction.
For instance, rather than typing 1/4, and having it
appear as three characters: 1, /, &...
|
|
1 |
437 |
|
|
Linked Workbooks by
NoSpam
Hi All,
I'm using Excel 97 at work and there are two workbooks that someone has
linked. I can't figure out how to unlink them. I go under "EDIT", "LINKS"
and...
|
|
1 |
527 |