Pasting to Rows with with text only
How can I tell Excel to paste data in column A, but only to those row
that contain data? I know there is a way, but how?
Thanxs in advance...
Message posted from http://www.ExcelForum.com
- copy and paste your data (including formulas)
- select column A and hit F5
- choose 'Special' and check 'formulas'
- hit 'DEL'
> How can I tell Excel to paste data in column A, but only to those
> that contain data? I know there is a way, but how?
> Thanxs in advance....
> Message ...How can I make a shortcut to OL Add-in Lookout?
I just downloaded Lookout--which I guess is a another .net add-in for
Outlook. I want to make a shortcut to Lookout if I can. Can anyone help?
Using MOS 03 on an SP2 RTM box.
You can't. It's an add-in so it only works from within Outlook.
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1
"Chad Harris" <email@example.com> wrote in message
>I just downloaded Loo...Changing text size
We enter all our customers in our database in all caps (text) for the
names, and addresses. But when you put in the zip code and the database auto
finds the town and state it is put in upper, and lower case.
Is there a way to change this default to all caps for the auto fill.
I am experienced in editing xml. files ( just a note)
Any help would be appreciated.....Dennis
No, there's no way to change that in the front end, that's something that is
happening at display time and is meant to make the data more readable. You
could enter a suggestion on Customer Sou...Lost Ability to Include Selected Text in Replies
Operating System: Mac OS X 10.6 (Snow Leopard)
I no longer seem to be able to select some text in a message, and begin a reply to that message quoting only the selected text. Either in HTML or plain text, the selected text does not appear. I have tried all Preferences>Compose, Reply permutations. Either all of the in-coming message is included, or none is included. Does anyone have a similar issue?
On 3/2/10 11:04 AM, AndyBobyarchick@officeformac.com wrote:
> I no longer seem to be able to select some text in a message, and
> begin a reply to ...Capitalize the 1st letter of text entered in a cell
I frequently enter text into cells. Sometimes the text is entered in
lower case letters. I want the 1st letter to be capitalized
regardless of my entry. Are there any suggestions? Thanks in
You can only do this with code. There is no formatting command that
can be used. Right-click on the appropriate worksheet tab, choose View
Code, and paste in the following code:
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ErrH:
If Target.Cells.Count > 1 Then
If Not Application.Intersect(Target, _
Me.Range(&q...How can I set Outlook 2003 default reply format to 'Plain Text'
Where is the setting which will default my reply in Outlook 2003 to be
in Plain Text format?
Currently I have to select the menu options "Format", "Plain Text" to
force the reply to text etc.
Outlook respects the message format in which the message was received. You
will need to force plain text.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After furious head-scratching, tech.Nik as...Saving from Excel to text
I am trying to save an excel spreadsheet as a text (tab
delimited) file but for some reason chracters are being
replaced with a '?', does anyone know why?
Any help would be greatly appreciated.
How are you saving the file? Try highlighting the
spreadsheet, copy, open Word, paste. Highlight the text
in Word, go to Tools, Table, Convert Table to Text, and
choose the Tab delimiter.
>I am trying to save an excel spreadsheet as a text (tab
>delimited) file but for some reason chracters are being
>replaced with a ...numbers as text
Using Excel 2007
I have entered a long numeric string (a bank account number) as text. The
entire Excel worksheet is then saved as a .csv file. The file is closed.
When the file is reopened, the long numeric string has been converted to a
scientific format (1.45684E+11) which can be converted again to text but
will not keep that format during the save process.
The bank is requiring the file to be saved in .csv format, so I don't have
the option of saving in Excel format.
On Tue, 15 Dec 2009 15:03:38 -0600, "BK" <firstname.lastname@example.org...Rotating Text Boxes on a Chart
Excel won't let me rotate text boxes in my pie chart.
When I go to do it the rotate buttons are greyed out.
Also I can't figure out how to add text the curves with
the outside of the pie chart. Please help! Thanx!
You won't be able to rotate textboxes.
If they are really data labels you can alter their alignment. But they
If you want text to wrap around the pie you could try using word art.
Although a pie with more than a few slices will probably result in text
not appearing next to the slice.
> Excel won't let me rotate...objects created in 2002 (2000 format) not avail in 2000 boxes
I have created a new query and report in an Access 2000
database. This is the first modification since my PC was
upgraded to 2002. The database is still in 2000 format
(according to the banner). Other users, however, do not
see the newly created query or report? (They are Access
My name is Amy Vargo. Thank you for using the Microsoft Access Newsgroups.
Is this database in a shared folder that multiple people can access, or did
you create your own copy of the database? Maybe you are using the wrong
file. Verify that the file is in 2000 forma...OL 2003 and problem with zip files
We have a problem on our office PC that has started since yesterday.
We receive .zip archives as a mail attachment but the last three we have
received will not open or save.
We have gone back to known good zip archives which have opened previously
from Mon/Tue this week & earlier and those now won't open on the same PC.
We have forwarded the email to another PC and this can open/save the .zip
archive as expected.
In addition the Subject line has mysteriously disappeared from within
Outlook but we have now got that back.
Does anyone have any ideas what could be causing the problem...Text Search Macro?
I have a large spreadsheet with a great deal of text. The workbook is shared
on a network of mostly Excel-phobic users who will need to be able to quickly
find text in the sheet. Of course, they could simply use the "Find" feature,
but I just KNOW that that will be a trap. I'd like to create a macro that,
when run, will generate a pop-up box into which the user will type the text
they want to find, and which will find the text in the sheet when the user
clicks "GO." (I'll connect up the macro to a big, friendly button marked
"Press Me to Search,&qu...Help
My Outlook 2000 won't remember my password, which makes it very annoying to
have to enter it every time I open Outlook.
I've tried checking the box "remember password" when the password prompt
comes up. I've tried checking the box "remember password" under
Tools>Services>Internet Email Properties>Servers>Incoming Mail Server.
I know it's not a function of my Internet mail server (comcast); this works
on my other machines.
I've also tried uninstalling and reinstalling Office2000, no luck.
Any Ideas ? Is there for instance a Registry key th...Center Text
I have what would seem to be a very small problem, but I am unable to answer
it myself. I have a report that I am trying to create and each record can
have one of three categories. If there are multiple records for, let's say,
Group1, then I want a text box to span both records and center the text
within the report. This would be the equivalent of a rowspan in html.
I have no idea where to start. Am I missing something really simple?
The data is structured as the following:
Group1 | Record 1 | Some cool info
Group1 | Record 2 | Some cool info
Group 2 | R...how do you stop excel changing text
When I transfer names from quick address to an Excel spreadsheet it changes
Mr to Mrs, Chester to Chesterfield, Lee to Leeds and so on. Is there any way
that I can make it accept what is on the quick address.
have you checked 'Tools - autocorrection'
"MK Chester" <MK Chester@discussions.microsoft.com> schrieb im
> When I transfer names from quick address to an Excel spreadsheet it
> Mr to Mrs, Chester to Chesterfield, Lee to Leeds and s...Adding plain text to a database?
I have some instructions (about 2-3 paragraphs) that need to accompany one of
Rather than sending them separately where they might get lost, how could I
include them within the database file?
Why not simply create a form and enter the text there. then you can add a
button so the user can access the info when they need it.
Hope this helps,
> I have some instructions (about 2-3 paragraphs) that need to accompany one of
> my databases.
> Rather than sending them separately where they might get lost, how co...superscript text in legend
I have created some superscript text in some of the column headings in my
table, i.e., Gender[a], Education[b], with [a] and [b] being superscriptted.
However, in the legend of my chart, the superscript text just appears regular
size, so it looks like I have committed typos.
Is there a way I can maintain the "superscriptness" of certain characters in
my legend text?
No. Unfortunately, when a chart uses a cell to title (or text box) it does
not take the format with it.
Bernard V Liengme
remove caps from email
"hogon" <hogon@discus..."Sales Receipt" Phrase Wraps onto Two Lines
Anyone know how to get the "Sales Receipt" statment on the 40 Column
Receipt formatted so that it doesn't wrap onto two lines? I tried the
paper width in receipt properties, but that didn't work.
Is there details somewhere on the different attributes for the receipt
properties? As an example, how do you determine the proper width?
What make & model printer? Windows or OPOS drivers? I have set paper widths
between 2.4 and 3.0 without problems. Also take a look at the right margin
settings. After making your change, click refresh and then print.
&quo...Text box visibility
On my form "Finalise Jobs" i have (amongst other controls), "Date ready" -
txtDateReady, "Date Required" - txtDateRequired, "WhyDelayed" -
txtWhyDelayed, and a search Combo Box - cboSearch.
The following code is attached to txtDateReady :-
Private Sub txtDateReady_AfterUpdate()
If txtDateReady > Forms![Finalise Jobs].txtDateRequired Then
Me.lblWhyDelayed.Visible = True
Me.txtWhyDelayed.Visible = True
Me.lblWhyDelayed.Visible = False
Me.txtWhyDelayed.Visible = False
and the following...Outlook 2002 won't send/receive. I have recently installed outloo.
I have recently installed a pocket pc on my system and want to run ACT!
now outlook 2002 and ACT! won't send and receive emails. It was working
initially but has just stopped.
I have re-installed outlook but with no luck
...97 conversion to 2002
I am about to take on a project converting hundreds of
Access97 DBs to Access2002.
Is there anything special I will need to know about this
Best places for resources if there is a problem?
> I am about to take on a project converting hundreds of
> Access97 DBs to Access2002.
> Is there anything special I will need to know about this
> Best places for resources if there is a problem?
The only such resource that I am aware of is at Tony Toews' web site, and the
Access 2.0 and Access 97 to Access 2000/2002 conversion issues/p...Replace text after punctuation
I have a number of cells that have text, some sort of punctuatio
(example : or -) followed by text. An example of cell would be; tex
text text: text text text.
I want to remove the punctuation as well as the following text by usin
the find & replace function. Is there some sort of criteria I can us
that would do this?
Message posted from http://www.ExcelForum.com
To make it simple, lets use Find/Replace to have only one punctuation.
Now select the cells and use Data|Text to Columns and specify that the text
is delimited by what ever punctuation symbol was used.
...Excel XP (2002)
Like to know if it is possible to do search find, to find a cell with a
certain amount of characters. That is, if a cell has 24 characters can
Excel find it based on having 24 characters? I imported a csv file which
has a column with various text that really goes past 64 characters, I like
to find all cells that exceeds a certain character "amount".
Using Xp Pro Sp2
Maybe you could use:
(24 ?'s surrounded by asterisks (*)).
> Like to know if it is possible to do search find, to find a cell wit...Hotmail OL attachment uploads
Since upgrading from OL XP to OL 2003, everytime I send an email from OL
with an attachment of any size or type, it seems to fail with an error
below. However, when i check the sent items folder, there are multiple
copies of the sent email therefore spamming the recipient's mailbox
unknowingly I think.
At the same time, trying to stop the file from sending from the outbox, I
can't delete the file when it is not sending until I access offline mode. I
now have to use the web based version to send attachments.
Need to stop this problem.
Task 'Hotmail - Sending' reported ...Text in auto text building block changes
I am new to 2007 and am trying to set up a template for our authors' use. I'm
using an existing 2003 template.
I created an autotext building block -- a table with our styles applied and
the name of the style. Added it to a custom gallery and put that on the QAT.
When I inserted the table, Chart Text style had changed to 10 point Times
New Roman and Chart Number was 12 point bold Arial in all caps. When I went
to the Style window, the style was correctly defined.
I'm using an older template that I have been a bit suspicious of --
numbering issues. Could it be co...