Formatted text in QuickParts/AutoText
I'm back with another issue. I cannot seem to get my saved QuickParts to
hold its formatting, specifically, underlining. So, in reading the boards, I
decided to use AutoCorrect instead, and apply formatted text settings. While
the text shows up formatted in the little window in the AutoCorrect tab, when
I insert it into my document, the underlining ONCE AGAIN is gone!
Is anyone else having these issues with autotext / quickparts functionality?
This entire feature in Word 2007 just does not work properly in so many ways
for me. Of course I'm not discounting us...how do you Create flashing Text
I am creating a newsletter and want one of the titles in the newsletter to
flash or blink. How do I do this?
Ask this here:
Mary Sauer MVP
"lukieguy22" <email@example.com> wrote in message
>I am creating a newsletter and want one of the titles in the newsletter to
> flash ...If/then to print text.
I want to use a formula so that when a value over zero is put into one cell,
a line of text prints in another cell. I know it is an if then function, but
I've forgotten the exact formula and the way to encode the text message in
> I want to use a formula so that when a value over zero is put into one cell,
> a line of text prints in another cell. I know it is an if then function, but
> I've forgotten the exact formula and the way to encode the text message in
> the formula.
=IF(A1>0,"print this text","prin...How do I extract text content from an exported .rwz file
Outlook 2003, Office Pro -
When you export Rules and create a .rwz file, the file is not a pure text
file as it seems to be loaded with null chars. I would like to extract the
long list of spam words used in a particular rule. Is there a way or a
utility which will remove all the nulls from the file so I may edit it to
get the contents I want ?
The alternative storage location is not any easier - trying to get the same
info, as it is similarly stored, out of the registry. :(
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-Backup and R...Getting text from hidden text producing error
I am using code to populate a drop down from hidden text (in text formfields) in a Word form. The code works great, however, I have now hidden the section that contains the text form fields and the code returns an error. Is there something I should be inserting in the code so that it can cope with hidden text/ bookmarks? I don't want to unprotect, unhide, run existing code, and then rehide and reprotect as this is cumbersome.
Select Case ActiveDocument.FormFields("scheme").Result
With ActiveDocument.FormFiel...TEXT problem...
I have a cell with the following formula:
TEXT(e2,"mmmm dd, yyyy (CSC)")
cell e2 contains a date formatted value, "March 27, 2004"
Question, although the formula appears to work in terms of
converting the date to a text datg (for manipulation
later), why does the result yield "March 27, 2004 (C0C)"
instead of "March 27, 2004 (CSC)"?
For some reason, the function is replacing my 'S' for a
Its because the S is being interpreted as seconds. Since you
(presumably) have a naked date in E2...Getting details and adding text to the receipt
I want to get some details from the Receipt and also want to add some text
to the receipt... How can I do this...
I tried to this with session.variable was not able to successed. I want to
do this through VB.Net... A example in VB will also do for me...
Waiting for your reply... :-(
Can provide a sample of what you have tried?
"Vicky" <Vicky@discussions.microsoft.com> wrote in message
> I want to get some details from the Receipt and also want to add some
> text...Formatting Cell Text
Can you set a text up to display number's in foot and
inches example 12 would appear as 1' 13 would appear as
this is not possible with formtas. You have to use a helper column for
this. see Chip's site for some more information:
> Can you set a text up to display number's in foot and
> inches example 12 would appear as 1' 13 would appear as
> 1'1' etc.?
Take advantage of a great deal
...IF to check color of text
I have a calendar made up of my work schedule. I have the days that
am working a font color of black. I have the days that I am off a fon
color of light gray.
I'm looking to use an IF function in which detects the font color, an
if true, add eight, otherwise add zero.
Is this possible?
Message posted from http://www.ExcelForum.com
You have to use a userdefined function.
See Chip Pearson's site for an example:
"eckaner <" wrote:
> I have a calendar made up of my work schedule. I have the days that I
> a...Dupe Text Attachments
All of a sudden, starting yesterday, every message I receive has an
attachment with a .TXT file with the contents of the message. It's like
getting duplicate messages. How can I correct that? Help...
I am having the same problem. I have isolated it to plain text messages sent
from Outlook 2000 clients. It doesn't appear to happen with 2003. It also
just started happening a couple of weeks ago.
> All of a sudden, starting yesterday, every message I receive has an
> attachment with a .TXT file with the contents of the message. It's l...Pasted text splits into separate text boxes.
Recently upgraded my Publisher program. When using a text box from a
template, and I try to paste text, it breaks the text, line by line into
separate boxes within the text box. I never had this problem with my
previous Publisher program. What's up with this?
A JackBird <A JackBird@discussions.microsoft.com> was very recently
heard to utter:
> Recently upgraded my Publisher program. When using a text box from a
> template, and I try to paste text, it breaks the text, line by line
> into separate boxes within the text box. I never had this problem
> with my previo...convert text to numeric values
My database (Access 2007) keeps track of bids from FE colleges. These are
made in an academic year (these span two 'calendar years e.g. 2009-10 for the
current academic year). Sometimes the bids are carried forward to, and paid
in, the following academic year. The 'Bid Year' and 'Paid Year’ are text
fields. When designing a query that will give me the total sum of bids made,
bids approved and bids actually paid, I can do separate ones based on 'Bid
Year' and 'Paid Year' but the totals are quite often different if a year has
bids that have been carr...Excel Options
Can anyone tell me how I can have the default setting in
Excel set to NOT wrap the text?
I do a lot of copy/pasting and it drives me nuts to keep
having to deselect the wrap text.
For me, the default is off.
But I think excel tries to help. If you paste text into a cell and that text
contains alt-enter, then excel says: you need wraptext on! And does it.
You could give up trying to do it after each paste and just do one mighty change
(all your cells selected) when you're finished.
or you could use a macro and assign it to your favorite shortcut key:
Sub t...Adding text to all outgoing messages...
I would like to add a text message to all outgoing mail messages. How
can i do this ?
for your text (assuming you are usaing exchange)...
They provide a free version that does disclaimers.
"Carlos Mendes" wrote:
> I would like to add a text message to all outgoing mail messages. How
> can i do this ?
check this vbs sample
"Carlos Mendes" <firstname.lastname@example.org> schrieb im Newsbeitrag
Take advantage of a great deal
....ps1 attachment preview with text previewer
How can I get .ps1 files to preview with the built-in text preview handler.
I have unblocked the .ps1 attachments so I can see them (in the registry)
and I have associated the .ps1 extension with the built-in text previewer
but I still get the message "This file cannot be previewed. Try opening the
file in the program in which it was created". I am an instructor and I have
students send their homework in via e-mail. Often times I like to quickly
view the scripts without saving the attachment. This is not a security
risk because you can't execute a powershell script dir...Unable to use original text prefix character
I want to use a '>' to prefix original text in replies and forwards. I
have it set up to do so in my options, but it still just uses the blue
bars around the original text.
I think the options are just being ignored. Even if I force plain text
format, it still composes in HTML unless I change it manually in the
new message's toolbar.
Anyone have any ideas on this? My IT guy cleared my profile and it had
no effect on the problem.
email@example.com <firstname.lastname@example.org> wrote:
> I want to use a '>' to prefix original text in replies and fo...Automatic colors for text
Can you set excel to automaticly fill in a cell color for specific text
- check out conditional formatting on the format menu
if you'ld like further assistance, please post back with more details
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"mogravy" <email@example.com> wrote in message
> Can you set excel to automaticly fill in a cell color for specific text
...change color if text is = or not, to text in other column
I am taking practice tests. ColB contains text (the correct answers). ColC
contains text (my practice answers). I want the cells in ColC to turn green
if my answer is correct (matches the text in ColB) and turn red if it is
incorrect (does not match the text in ColB).
I can't figure out how to get it to apply Conditional Formating on the
columns. It wants me to apply it to only a single cell. I've also tried
copying and pasting special just the formatting. It turns the cells in ColC
green if they match cell B2 (not the corresponding answer that is in the same
Please ...Can clip art be put behind text in Publisher?
I would like to lay text on top of a very light image of a dove. I can
achieve this by first printing the dove clip art, and then feeding the paper
through again and printing the text on top of the dove image. It looks
great, but since I have to print 100, is very time consuming. Any ideas?
Put the image on the background (master page) ctrl+m.
Mary Sauer MS MVP
"Mary P." <Mary P.@discussions.microsoft.com> wrote in message
news:E2BC3F23-9298-4F14-9907-1E64DFCEFBC3@micro...text as 0
I have cells formatted as 'text' in several worksheets linked to a text cell
on a 'master' worksheet. When I enter text in the cell on the master
worksheet, it is copied into the cells on the linked worksheets. However,
when I delete the text in the cell on the master worksheet, I get a '0' in
the cells on the linked worksheets - rather than a blank.
How can I format the cells in the linked worksheets to just show a blank,
rather than a '0'?
You can use a custom format like
or you can change the link to
I have a report that tracks the dates certain events happen.
Date Request received
Date sent out
How do I get the report to display the text "Not Available" if there is no
date recorded in the table?
The NZ function is your friend here ;-)
The Nz function replaces nulls with zero by default, but can be used to
replace a null with any value/string you want. So, to display "Not
Available" if a field named RequestDate is null, you enter the expression
in the textbox which is displaying the [Req...Text String Separation
Is there a function opposite of "CONCATENATE"? I have a list of names
with the first and last names in the same cell. Doesn't do well if you
want to sort by last name. I diregress, rather than re-typing the whole
list I would like to know if anyone knows how to split the string at a
Thanks for your help.
Data>Text to columns
See HELP for more details, if it is not self-explanatory already
"TexasLegend" <firstname.lastname@example.org> wrote in message
> Is...How do I arch a line of text within a banner?
I am trying to design a banner that will have two lines of text. Rather than
both lines being straight, I would like to arch the top line over the second
line so that I can insert artwork between the two lines of text. Can this be
accomplished with this program? If not, is there a program available the I
could use instead.
> I am trying to design a banner that will have two lines of text.
> Rather than both lines being straight, I would like to arch the top
> line over the second line so that I can insert artwork between the