|
|
Extract a number from a cell of text by
pnoel
I am trying to find out what formula I would use to
extract the number from the following cell:
Numer of items in truck,13625.
Then place the number in...
|
|
2 |
877 |
|
|
Formatting Column with all Caps by
Dean
Is there anyway to format a column to take data from
another column and convert it to all caps? I can get the
data from another column but can't seem to get it...
|
September 15th, 2003 05:06 PM
by Andy B
|
1 |
375 |
|
|
Networkdays calculations by
Linda
Everytime I enter the formula, =networkdays(l5,k5) to
calculate how many days an employee will receive his/her
new rate of pay for the new fiscal year, it...
|
|
2 |
390 |
|
|
Comparing ranges by
ibeetb
I would like to compare Range A and Range B and then be able to identify or
write out the items in A that re NOT in B.
Keep in mind,, that range B has unique...
|
September 15th, 2003 05:20 PM
by john
|
1 |
391 |
|
|
#N/A by
Bob Phillips
thanks bob..that did it..thanks for taking time to help
-----Original Message-----
Steve,
=IF(ISNA(vlookup_formula),0,vlookup_formula)
--
HTH
|
|
0 |
443 |
|
|
filtered list by
Pam Coleman
If I have done an advanced filter from a Master db and
filtered a list of juveniles within a 3 month period, and
in that list some of the juveniles are listed...
|
September 15th, 2003 05:29 PM
by Lance
|
1 |
409 |
|
|
Compare 2 Worksheets & Find Matches by
Mark
Can anyone tell me how to compare 2 worksheets and where
there is an exact match of text in a cell to return a list
of matches? Or in someway highlight the...
|
|
1 |
529 |
|
|
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 |
|
|
|
|
1 |
398 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
|
|
1 |
427 |
|
|
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 |
|
|
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 |
|
|
|
|
2 |
669 |
|
|
|
|
1 |
378 |
|
|
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 |
|
|
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 |