counting text strings
This is probably really simple - but how can i count how many cells in colum
contain a certian text varible ?
will count the number of cells in column A that are equal to "sometext"
will count the number of cells in column A that contain "sometext"
Keith Rathband wrote:
> This is probably really simple - but how can i count how many cells in colum
> contain a certian text varible ?
...Alphabetizing text within a paragraph
I am in the process of creating a web page on Microsoft
2000 for our health-based non-profit. Within the page,
there is a paragraph of words (different medical diseases
and conditions) that I would like to alphabetize. Whenever
I follow the directions as to how to sort, Microsoft tells
me that it found no material eligible to sort
(alphabetize). I would like to keep these words within the
paragraph (each word is separated by 5 spaces) and
alphabetize them accordingly. I further want to use each
alphabetized word as a link to a phyto-medicinal cure that
I am planning to write further down on th...can text be inverted by 180deg
Is it possible to invert text by 180 deg. Under Format - cells you onl
have the option of 90 deg
tryer's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1654
View this thread: http://www.excelforum.com/showthread.php?threadid=39979
from my archives
sometime back i used this formula
my original data is in B1 to B16
I copied this to any cell and copy down
may be easier solutions available
tryer <tryer.1ugkia_1125205502.54...Text not copying as text from Word to Excel 2003
I have a column of data in Word that contains info like, K-12, K-6, P, 9-12,
6-8. When I copy the data to Excel, the cells with the letters copy
correctly, but the cells with the numbers convert to dates. I've tried
pre-formatting the target cells in Excel, I've tried Data | Text to Columns,
I've tried preceding the data with a single apostrophe before copying the
data from Word. Incidently, this "works" but when I find and replace the
apostrophe, the text gets converted to a date! Can anyone help? Thanks in
"Christine" <Ch...Problem replying email
A user when replying emails (from MS Outlook 2003) to some of the internet
users, it always undelivered and bounce back (refer to below for the
errors). But when user manually keyin the email address, it sent
successfully. It always happened on these 3 domain email accounts.
The e-mail system was unable to deliver the message, but did not
report a specific reason. Check the address and try again. If it still
fails, contact your system administrator.
<smtp02.nafa.edu.sg #5.0.0 smtp;550 5.0.0 ... Use MXes or
There was a SMTP com...View with selectable text/images
Does anyone know what kind of CView MSN is using for the chat window (the
window with the selectable text and smileys)?
If it isnt a CView, can i get some pointers on how to make a view with
selectable text and images?
Thx in advance :)
Thomas 'Da_QuiK' Schueremans
Use Spy++, it shows that it is a RichEdit View.
"Thomas" <Da_QuiK@fake.email.com> wrote in message
> Does anyone know what kind of CView MSN is using for the chat window (the
> window with the selectable text and smil...Creating a contact group from text file
I got 10 e-mail addresses in a word text file
can I somehow make it into an address group or contacts without having
to open a card manualy for each one and typing name nickname e-mail
You need to make sure it is in the correct order, however, you can add
commas between fields and import it as comma deliminated file. It is one of
the options for importing.
"ronba" <email@example.com> wrote in message
> I got 10 e-mail addresses in a word text file
> can I somehow make it into an address group or c...Linking styles to Body Text style
I'm curious how the pros link their "body text" style to other
styles.... assuming they do.
The reason for my question is how I defined my List Styles and some
non-TOC heading styles.
First, I decided to use a "vanilla" body text style (call it bt1)
without the "leading" (space before/after the paragraph) that I use for
most of my documents.
I then linked (based on) that style (bt1) to my list, heading and other
And I defined another Body Text style (call it bt2) with the leading I
normally use for documents and linked it to tha...reply text
how do I change the default text when replying to a message and als when
replying to a post in Outlooks newsreader, Outlook Express.
...How to change text in a rich text box?
I have a dialog box with a richEdit box in it (IDC_DISPLAY). I need to
change its text when a user clicks on Start button. How do I send new text to
this richEdit box?
Moreover, how can I get this richEdit box's hDC? using GetDC()?
Thanks a lot for your help, the more details, the better. (I used more VB
than VC++, and this is a new function I need to add to our VC++ MFC app).
SetWindowText works fine for htis purpose.
You do not want or even want to think about the hDC or GetDC(), since there is nothing you
could possibly do with it that could make sense. Paintin...Extracting Text in a string of text
Happy Holidays to All!
How do I extract a concatenated field so I have exactly what I need.
I've used the Left and Right functions, but I need to extract more
precisely without having to guess the number of characters. For
New York, NY 10019 I want to extract out the "NY" or the state. How
do I do that given I may have multiple city and states?
Thanks for any help:confused:
walkerdayle's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=10021
View ...Producing fix width text files
I want to export an excel file as a fixed width text file. I will have four
columns I want each to remain 10 charactors wide with the text left aligned
and numbers right aligned. How do I export in this format ?
I'd use a helper column that would concatenate the values in the first for
(all one cell)
Text in A1 and C1, numbers in B1 and...how to get the alternative text of pic from an excel file
This is a multi-part message in MIME format.
i have an excel file containg alot of photos , how can i get the =
alternative text of all these photos , the there any function can help . =
or any way=20
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML dir=...Auto Populate text box based on combo box
I have a combobox named "Bulk" and a text box named "Routing", I would like
the Routing box to auto populate after the user selects an option from
"Bulk". The Bulk combo box is bound to a table named "Products and bulks".
The Routing selection would be coming from the same table.
Could someone please explain this to me? I have tried different codes like:
Private Sub cboPersonID_AfterUpdate()
Me.txtPersonName.Value = Me.cboPersonID.Column(1)
Everytime I put this in the Combo Box's afterupdate property, an error
message com...Function for comparing text and number combinations
I'm trying to compare a cell value with a column of cells that contain a mix
of numbers and text but I want to ignor the text. The values in the cells are
2 numbers followed by a letter then 3 or 4 numbers, eg. 45F254 or 56G2541. I
would like to get a 'true' statement for cells that contain 45D254, 45T254 or
56E2541, 56Y2541 and a 'false' return for 45F587 or 56R5874 etc. Is there a
function that accomplish this?
A1 should be your "key" as in 25
A3 is the cell you are searchin
If A3 Contains 45D254 and A1 contains 254, it will retu...Copy text box with text and clip art to another PUB
Is it possible to copy and paste a text box from one Publisher document into
another one as a complete unit - box, text, little clip art images, etc. Or
do I have to cut and paste all the bits and pieces separately. I need to
copy several text boxes with their contents from a newsletter to another
PUB, and doing it piecemeal looks like a long, tedious process.
Group everything and then yes, it can be done.
MVP Microsoft [Publisher]
How to ask a question
"Orrie" <EB3551@operamail.com&g...Cell won't show text
Hi--having a major problem with the cells in my worksheet not displayin
text. There is a fair share of text but it just stops and no matte
what I do to format it to show the text it won't--what am i doin
wrong?? Any help would be greatly appreciated!
nicolebelle's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2884
View this thread: http://www.excelforum.com/showthread.php?threadid=49278
How many characters are you trying to display in a cell?...Navigate to a particular link doesnot display the text sometimes
Have used navigate method of IWebBrowser2 in a property
page to display the htm file. Debug prints shows the
correct path is given for a link ( eg path for one of the
hyper links path is C:/../team_typesENU.htm#aft) inside
htm file . Sometimes the contents of the file does not
get displayed .Contents are shown only when clicked on the
control itself or navigate between the pages. text is
hidden. anybody can let me know why is this happening ?
Do you know when you will be going around with them, the only reason I ask
is that if my Truck is not at my Apt. I maybe still over here at Mom's.
Just call my house phone as it is forwarded to my Cell phone all the time.
Take Care, Mark.
Sure, no problem. What kind of cookies do you want?
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
"Mark Thomas" wrote:
> Do you know when you will be going around with th...book plates
Can you create book plates in publisher, or another program?
You certainly could - quite nicely too.
MVP Microsoft [Publisher]
How to ask a question
"carneu" <firstname.lastname@example.org> wrote in message
> Can you create book plates in publisher, or another program?
A really nice one here, might give you an idea on how to layout your
publication. It is for Word but can be adapted.
http://office.microsoft.com/en-us/templates/TC010220071033....Logical Test: Text Against Number 01-05-10
Can anyone provide insight into how Excel treats this type of test? For
example, why does Excel return TRUE when we have ="a">2 but FALSE when ="a"<2
(or any other number for that matter).
That's the way it is treated. Any kind of text is larger than the largest
Any worth? hit the YES below
> Can anyone provide insight into how Excel treats this type of test? For
> example, why does Excel return TRUE when we have ="a">2 but FALSE when ="a"<2
...Text in Cell as Formula #2
Peo + Julie Many thanks for your answer with the last query.
I Have a similar question, please advise:
This method [INDIRECT()] does work with values form a different spreadsheet.
I type the link (as text) from a different spreadsheet in a cell in the
current spreadsheet and use this method to call a value in a cell.
Would appreciate a detailed answer (if complicated) - I'm a novice user!
Many thanks in advance.
...Plain text warning/ VS2005
Whenever I add a CRecordset derived class, I get an error telling me the
password for the DB is sent in "plain text" and is not secure etc. I
comment that line out, but how much of a security risk is this? What can I
do with my Access database to avoid this? VC 6.0 never gave this error...
If you are on any kind of network that anyone can look at, you are wide open for attack.
Example, a University network; potentially, ever student can be running a packet sniffer
and see your password. Anything that passes acros the Internet outside your local
intranet is also vuln...Rotate text?
Is there anyway to rotate a specific word in a sentence?
Not if it's part of the sentence rather than being a separate text box.
MVP Microsoft [Publisher]
"L." <email@example.com> wrote in message
> Office(publisher) 2K.
> Is there anyway to rotate a specific word in a sentence?
Thanks for the info.
"JoAnn Paules [MSFT MVP]" <firstname.lastname@example.org> wrote in message
news:U46dnd7PfZ5CTBHenZ2dnUVZ_sidnZ2d@suscom....shading behind text
I would like to place white text within a box of gray shading. When I
use the 'background' function, it shades the entire document. How do I
limit the background to a line of text?
Depending on your preference I can think of at least 3 ways, but they all
may not be available to you... or instructions may vary. It depends on what
version of Word you're using & you haven't even indicated whether it's
Windows or Mac. Since you posted to the Mac Word group I'll assume you're
using a Mac version & further that it is the most current (2008):...