Is there any way to extract an icon from an application?
Take a look at the ExtractIcon[Ex]() API
<firstname.lastname@example.org> wrote in message
> Is there any way to extract an icon from an application?
...extracting totals from within a spreadsheet
I need to know how to take different information from within a spreadsheet
--where two conditions/catogories must apply so that a third column where i
have inputed hours, will total for those conditions only... can anyone help?
Please spell out what you want we are not mind readers
Bernard V Liengme
remove caps from email
"Jovetta" <Jovetta@discussions.microsoft.com> wrote in message
>I need to know how to take different information from within a spreadsheet
> --where two condi...Excel: extract and sum numerals from mixed text/numeral cell range
I have a large (30x20) grid of cells with data, and I want to extract
and then sum up certain numerals from this entire range. The catch is
that the data is mixed numerals and text, as you'll see below.
Here's an abbreviated 3x3 example, with a value in each of the nine
V7.1 T H
P1 A T
B V3 P4.5
If I just wanted to sum up the instances of "T" appearing, I could use
COUNTIF() for the entire range to come up with answer ("T" appears 2
times). Easy enough.
But, what I'm trying to accomplish is to sum up the numerals associated
w...extracting individual numbers from "ranges"
I'm trying to get EXCEL to extract stock prices quoted in individual cells
as 52-week ranges --e.g. 11.76-19.90-- and do the following calculation:
(higher price - lower price)/lower price
Obviously, this a problem because each cell appears to handle the range as
text or something. Is there are way to get EXCEL to handle the "text" (or
however else it is interpreting what's in the cell) as individual numbers?
Great thanks for any help.
do your entries always look like
if yes you may try the following formula in the adjacent row (lets
assum...Query and Extract
This seems basic, but I just cannot get it. While using SQL Server 2005 and
the Microsoft SQL Server Management Studio, I created a database called
AssetQuote. Inside I have on table called assetquotes.
From there, I have three columns, (date, quote, author)
The column type for date is datetime and the other two are just text.
My Query is something this:
INSERT INTO AssetQuote (date, quote, author)
VALUES('052010','No act of kindness, no matter how small, is ever wasted.',
When I run the query I get this result:
Msg 208, ...Extract emails from cells with text
I have a row in column A which includes an email address in the text that I'd
like to extract to column B. Is there a formula I can use to accomplish
extracting the email address only to column B?
Here's an example of different cells in column A:
Please email email@example.com to contact us......
Schedule an appointment for assistance, or email firstname.lastname@example.org with your
All on one line:
(" ",A1&" ",FIND("@",A1))-1)," ",
REPT(" ",...extracting hours from a sum of time
I have a cell which sum a bunch of cells containing an elapsed time.
The sum totals to more than 24 hours.
I have to a cell with a cost per hour and I need to caclculate the
The problem is that the hour function returns values in the range of
0-24. My current sum is 25:30 and the hour function return 1 and not
Any ideas how to bypass it?
It "returns" the correct number, but doesn't show. Format Custom as [h]:mm and it will.
To convert to a number that you can multiply with an hourly rate, first multiply by 24; times in Excel are fractions of a day and
a day is s...Can I extract unique cell values from every nth column?
I have a range that covers B5:XA160. For each row, data is entered in
11-cell groups: date, some numbers, description (a text value), more
numbers, and more numbers. At first it was enough to merely count how
many times certain descriptions appeared, because those were the only
ones we would see - or so the story went. Now, I need to extract the
unique descriptions AND provide a count!
Actually, I'm cheating a bit. I'm using SUMPRODUCT to return the
number of times the expected descriptions appear, and by subtracting
these from the total number of text values I get a count of &quo...Extract Text
I have this text in a field:
and I need to separate only the data after the six first data:
How can I do it?
Thanks a lot!!!
Take a look at Access HELP for the Mid() function. Open a query in design
view and add a new field something like:
Microsoft Office/Access MVP
Microsoft IT Academy Program Mentor
<email@example.com> wrote in message
Do anyone know of a tool or script which I can use to extract users email
address from a windows 2000 domain we are using exchange 2000
Here's a script to extract ALL email addresses form a domain:
Do you need something for a single user?
"wmb" <firstname.lastname@example.org> wrote in message
> Do anyone know of a tool or script which I ca...MID formula not extracting what I want.
I'm trying to extract the date from a cell using the MID formula and all
I'm getting is some weird number that does not seem to make sense.
I have tried formatting the target cell but still no change.
Any clues about it? How can I do this?
1/13/2006 12:16:29 AM
wayliff's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29860
View this thread: http://www.excelforum.com/showthread.php?threadid=501062
That's because Excel stores dates as...Extracting data to make mailing list
My neighbour has a .PUBS name and address doc. The doc is 10 pages long. Each
page of the document is a table with 10 rows and 3 columns.
Each cell is name on top the line followed by 2 or 3 lines of address. She
then just cuts the full sheet Avery into mailing labels.
This has become too difficult to manage, sort, filter, etc.
Anyone have a suggestion how to extract this data so I can make a Publisher
try bringing it into Excel...you'll some "massaging" to do.
Microsoft MVP Expression
these r the data given in Sheet 1 and i want the highest number in the month
of august in sheet 2
this is an array formula, so commit with Ctrl-Shift-Enter not just Enter
"sajith" <email@example.com> wrote in message
> Month Number
> AUG 1
> AUG 2
> AUG 3
> AUG 4
> AUG 5
> AUG 6
> S...Extract text content from MS office files
I want to extract text content MS-OFFICE documents like word, ppt, xls...
Plz gimme some tips.
...Extracting First Letter
Can anyone help, i'm trying to extract the first letter of each word within
any given phrase. I'm using excel 2003
Perhaps this might suffice
With text running in A1 down
In B1: =LEFT(TRIM(A1),1)
> Can anyone help, i'm trying to extract the first letter of each word within
> any given phrase. I'm using excel 2003
Sorry Max, let me be more specific, eg. Lets say I have the phrase "The quick
brown fox jumped over the moon&qu...Extracting folder data / Outlook won't open
I can't open Outlook, because it doesn't recognize Outlook Express is
installed (I have the often reported, but apparently rarely solved,
Is there a way to pull the mountains of data (calendar, tasks,
contacts and saved messages) out of my Outlook data file from another
PIM program? I'm willing to go with any other program to get away from
buggy Outlook, and figure one of the third-party sync programs will
handle the issue of how to sync with my Pocket PC.
firstname.lastname@example.org, you wrote on 23 Mar 2007 14:57:55 -0700:
> I can't open Outlook, beca...String extraction
How can I extract the first line form a multi-line string?
> How can I extract the first line form a multi-line string?
Use Left(yourString, InStr(yourString, Chr(13) & Chr(10))) to get the
--> stefan <--
"Stefan Hoffmann" <email@example.com> wrote in message
> hi John,
> John wrote:
>> How can I extract the first line form a multi-line string?
> Use Left(yourString, InStr(yourString, Chr(13) & Chr(10))) to get the ...extracting unique #'s from multiple columns
I have some data in two columns and i want to extract the uniqu
records, I would use a combination of the if and countif if I wer
only dealing with 1 column but with two columns I am stumped.
i NEED TO BE ABLE TO SEPERATE AND COUNT THE UNIQUE RECORDS
Message posted from http://www.ExcelForum.com
- create a helper column C
- in C1 enter the formula:
=A1 & "^" & B1
- copy this down and use your approah ...Programming to extract automatically extract attachments
Can anyone teach me how to write a code to automatically extract attachement
from incoming email sorted out into a pre-assigned folder.
(Note: The incoming email always has a fix caption and it already sorted
into a pre-assigned folder)
Background:- The emails are send from my surveillance camera when it detect
This example demonstrates how to extract an attachment, skip the printing
part. If your folder is not the default inbox but a subfolder of it, add
this in Applicaton_Startup before setting the Items variable:
Set Folder...Extracting Data
Hi really hope someone can help
I have been sent a Word documents 250 pages long and which contains
addresses. I need to get these into either Excel or Access.
Each address is 4 lines and there is 2 or 3 line feeds between each address.
Is there anyway I can extra this data into and Excel worksheet or Access
Very many thanks
On Sun, 28 Mar 2010 16:50:41 +0100, Alex Hammerstein
>Hi really hope someone can help
>I have been sent a Word documents 250 pages long and which contains
>addresses. I need to get thes...preventing resources from being extracted in a win32 executable
Does anybody know how to prevent the resources (icons, bitmaps) from
being extracted from a win32 executable?
<firstname.lastname@example.org> wrote in message
> Does anybody know how to prevent the resources (icons, bitmaps) from
> being extracted from a win32 executable?
The only way is to encrypt the resources, perhaps storing them in an
You can encrypt them, as suggested, but the decrypt code can be reverse-engineered and
thus easily cracked. It also means you can'...Extracting Data #4
I will like to create a formula that will extract dava
from a column of text that has quatation. So in the
column any text that has "" in the word extract it.
I tried everything.
Thanks in advance!
not quite sure about your data. could you give an example?
"Dave" <email@example.com> schrieb im Newsbeitrag
> I will like to create a formula that will extract dava
> from a column of text that has quatation. So in the
> column an...Extract Unique Values, Then Extract Again to Remove Suffixes
I have a list of builders where I want to extract all the unique values.
Using =IF(COUNTIF($A$1:A1,A1)=1,A!,"") works fine to get the first set of
unique values, but I need to extract it a bit further. The builder names
may be Ryan 50, Ryan 60 or just Ryan. I need to combine those values to
come up with the final list of unique builders that just says Ryan. I'm not
sure if I can strip off anything from the end as some are Ryan - Greenbrier.
I thought maybe removing everything to the right of a blank space, but those
entries have 2 blanks.
Any help would be greatly appr...Extracting from 1 cell and placing extractions in multiple cells
I receive the following data in a (3) cells:
SYS DESKTOP PIII 500 6.4 G 128M 40X 1.44(1 cell) DELL(1 cell) OPTIPLEX
Is there any code or command that would extract and put in multiple
Dell Optiplex GX1 (one cell) DESKTOP (1 cell) PIII500 (one cell)
128MB (one cell) 6.4 G (one cell) 40X (one cell)
The RAM (128MB) can be anywhere from 32MB-512MB
The HDD (6.4 G) can be from 1.2-20.4 G
I receive in 100 computers from a company and it takes me an hour (at
least) to type in this stuff manually.
Your help would be appreciated. Thank you.
---------------...Extract dd and mm from text and put that plus current yy in another
I've got a workbook which comes from someone else and it's got a cell
in it from which I want to get the above. The format of the cell
varies. It could be texttexttext 17Feb09, texttexttext 17th Feb,
texttexttext 17 February 09, texttexttext 17th February 2009, etc (but
never Feb 17 - I'm in UK not US!)
Try Text to Columns (in the Data menu). It should convert most every date
"robzrob" <firstname.lastname@example.org> wrote in message
> I've got a workboo...