|
|
|
|
7 |
418 |
|
|
reversing lastname, firstname by
Mich
I have a list of names that have lastname, firstname in
one cell. I would like to make it firstname lastname in
one cell. Thanks you.
|
|
2 |
370 |
|
|
Date List by
JP
I have a column of dates that looks something like this:
A
9/1/03
9/1/03
9/1/03
9/2/03
9/2/03
9/4/03
9/4/03
|
|
1 |
282 |
|
|
Excel Conditional Formatting? by
Ben Blackmore
Hi,
I have our company IP address range in excel format. I want to do
conditional formatting so I clearly see the different scopes. If I do
conditional...
|
|
3 |
852 |
|
|
|
September 15th, 2003 07:35 PM
by Ying
|
0 |
407 |
|
|
ISERR vs ISERROR by
Biff
Hi Folks,
The only difference I can see between these two is that
ISERR will not handle #N/A. Also, what about ISNA? Is
there any advantage in using ISERROR...
|
|
8 |
447 |
|
|
Line spacing by
Rupa
Does anyone know how to increase line spacing in Excel? I
don't seem to be able to do it
Thanks
Rupa
|
|
1 |
532 |
|
|
Calculating Duration by
Barbara
Hi, I am trying to set up a spreadsheet calculation where
I determine the duration in days between a date entered in
Column A and a date entered in Column B....
|
September 15th, 2003 07:11 PM
by Barbara
|
2 |
355 |
|
|
Countif using Criteria "<>""" ? by
RagDyer
Thanks Tom,
Never heard of "UsedRange" concept before.
(Lots'a things I've never heard of !)
But are there any other functions with similar...
|
September 15th, 2003 07:11 PM
by RagDyer
|
0 |
534 |
|
|
|
|
1 |
378 |
|
|
|
|
2 |
669 |
|
|
Formula by
pnoel
I need to extract a number from a text string, then list
the number in a diffrent cell.
Please Help.
pnoel
|
|
3 |
417 |
|
|
Bolding specific text in a formula by
Scot Rundell`
I am concatenating 3 cells, '=a2&b2&c2' and with the
result of this, i need the text that is in cell b2, to be
bold, so that i can get an answer of 'This is...
|
|
4 |
444 |
|
|
|
|
1 |
427 |
|
|
concatenating cells by
Rosson Cain
Hello, I need to concatenate two cells together. The
problem is that the first cell always needs to be 6 digits
long (e.g. if the entry is 23456 it need to...
|
|
2 |
299 |
|
|
Vlookup or Offset question by
Bill
Not sure how to accomplish this so i will attempt to explain. Any
assistance would be greatly appreciated!
Sheet1 - consists of four columns of data for...
|
September 15th, 2003 06:34 PM
by Bill
|
2 |
305 |
|
|
Calander by
John Mansship
Let me rephrase my Calander question.
Does anyone know how to copy the date clicked on the
calender to a cell?
Example: In Excel VB, I inserted a calander...
|
|
2 |
325 |
|
|
attaching website links to excel file by
lori
I am creating an excel file that I want to insert website
links that I can access right from the excel file by
double clicking them. I was able to do it in the...
|
September 15th, 2003 06:26 PM
by JM
|
1 |
373 |
|
|
|
|
1 |
398 |
|
|
Change Case by
Gary Ballance
I have the same question. Is there an easy way to change
data in an entire spreadsheet from lower to uppercase?
|
|
2 |
329 |