Where is the Keep Text Formatting feature located in Word 07
I believe this Keep Text Formatting feature might be what I need, but I have
been unable to locate exactly where it is located in Word 2007. I'm trying to
rid a Word document sent to me of tables, text boxes, graphics and all other
document formatting, while retaining the document's text content. It is
unimportant to me whether the text formatting is retained or not. Thanks.
Are you referring to a Keep Text Formatting feature in an earlier
version of Word?
I wonder whether what you're looking for is "Paste Unformatted," since
you seem to be saying you _don...Can I delete parts of Office?
I recently loaded Office 2004 on my iBook but want to conserve hard
drive space for an app i just picked up, and was thinking about
deleting all the MS apps except for Word and Excel. Can I do this
without messing up Word and Excel to the point that I need to
I would just try it, but I'm away from home and don't have access to my
Office install CD.
Any help that could be provided would be great.
> I recently loaded Office 2004 on my iBook but want to conserve hard
> drive space for an app i just picked up, and was thinki...test 05-11-10
...***Delete UNREAD email >90 Days (Exchange 2003)
I'm trying to delete all UNREAD emails older then 90 Days. Recipient Policy
will only let me select the date but there isn't a selection for UNREAD
emails. Exchange 5.5 Cleanup Agent (I think that's what it was called) had
a check box for UNREAD emails. Is there way to do this in Exchange 2003, or
is there 3rd party app that will do this?
Boy I miss Exchange 5.5!!!
when you create a recipient policy (mailbox-managed), you can set the age in
days (i.e. 90 days) and size in KB for all items in the selected folder for
which the policy applies t...Where is the Delete Messages options?
I've looked and looked without success. I'm pretty sure I saw it before.
Its where it asks you if you want to save a copy of messages on the server
and then should give an option for it to be deleted from the server when
you delete it from your Deleted folder in Outlook. That seems like a good
way of syncing things.
Gary Gary wrote:
> I've looked and looked without success. I'm pretty sure I saw it before.
> Its where it asks you if you want to save a copy of messages on the server
> and then should give an option for it to be deleted from the...stop duplicate entries using validation
I have a named range (one entire column) where I would like to enter SSNs using the data form, But I do not want any duplicate entries. I know the validation function can be used! But I can't seem to find the way. can anyone help?
Use Data Validation.
Select column A, goto menu Data>Validation, change the Allow option to
custom, and enter a formula of =COUNTIF(A:A,A1)=1
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Dennis" <email@example.com> wrote in message
new...Server Application Unavailable 06-14-06
In one of our customer's site CRM 1.2 is implemented on the following
SBS 2003 (with relevant SPs)
SQL Server 2000 (with relevant SPs)
MS CRM 1.2
MS CRM intermittently gives "Server Application Unavailable" whenever I try
to access CRM. All the services are running. No event logs. Although the
error message says that an Application Event Log for the Web Server has been
logged, I dont see any log in the Event Viewer. And moreover CRM also
displays the authentication form before giving that error. That means the CRM
Authentication service is...Adding new rows
I have a spreadsheet with 100 rows in, I need to add a row after each
current row, is there a quick way to do this or have i got to insert
each new row individually?
Paul Sheppard's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24783
View this thread: http://www.excelforum.com/showthread.php?threadid=390760
I assume you want to add an empty new row in between the existing rows.
One way would be with an extra column
Save as "trial" first.......just in case thi...Data displayed that is not equal to FALSE in a row
In row 1 cells A1-D1 contain formulas (IF/AND statements). In cell E1 I want
whatever word that is not equal to “FALSE” to be displayed.
A B C D E
1 FALSE FALSE Under FALSE Under
The words can appear in any of cells A-D in each row as below.
A B C D E
1 FALSE FALSE Under FALSE Under
2 FALSE On FALSE FALSE On
3 Over FALSE FALSE FALSE Over
4 FALSE FALSE FALSE On On
Thank you in advance for your help.
Gary''s Student - gsnu201001
Thanks Gary. That works great!
"Gary'...populate a listbox with values from rows in another worksheet
How would I populate a list box with values from rows in anothe
Message posted from http://www.ExcelForum.com
> How would I populate a list box with values from rows in another
Give the range with the values a name (insert, name, define) and use
that name as the listsource property.
Jan Karel Pieterse
You'll have to use a named range. Select the range and
press Ctrl+F3 and give it a name like "mylist" (no quotes).
Then under Properties of the Listbox use mylist for the
H...Conver Numbers to Log 10
How do I convert column of numbers (n=3000) to log 10 column of numbers?
Assuming that your column is column A, one way:
In an unused column, enter
and copy down 3000 cells.
Copy the column, choose column A and choose Edit/Paste Special,
selecting the Values radio button.
In article <0CDE6301-FC9C-488C-9D9F-3AD26B46EFCE@microsoft.com>,
"Fishfan" <Fishfan@discussions.microsoft.com> wrote:
> How do I convert column of numbers (n=3000) to log 10 column of numbers?
...How do I change the row/column format in a macro to beyond letters?
I recorded a very long VBA macro in Excel and the index of ranges is
in letter format,
for example, "M14:M19", etc.
Now I am going to run this macro programmatically and automatically in
a for loop and expand it from the left to the right so I want to
change the "M" in the above example automatically.
But after 26 letters, there will be AA, AB, etc. which is really hard
Is there a way to adapt the recorded macro (by changing as little as
possible) to more than 26 letters.
I really want to change as little as possible because I spent lots of
time re...Delete 3 end row
I want to delete three end row of any sheet. any sheet has different row
Thank's for any help.
This will clear the last 3 rows of the active sheet. Note I the on error
line is to cope when there are less than 3 rows on the sheet
Dim LastRow As Long
On Error Resume Next
LastRow = ActiveSheet.Cells.Find(What:="*", _
ActiveSheet.Rows(LastRow - 2 & ":" & LastRow).ClearContents
Whe...Deleting a single character in a text field
In one of my tables i have a field that has a text values like '123.23123' i
would like , to delete the full stop. How can i do this. I cant do it in
excel as the number of records that i have is over 200000.
> In one of my tables i have a field that has a text values like '123.23123' i
> would like , to delete the full stop. How can i do this. I cant do it in
> excel as the number of records that i have is over 200000.
Create a update query, use
Replace([yourField], ".", "")
as new value.
--> stefan <--
...First row in Selection range (first index of a cell)
I have a problem with selecting first cel in selection Range or return
an index of the first cell in Selection Cell.
I have something like this:
"and here I want to Select the first range in selection Range1"
I there any special function of finding first cell in selection range
or returning an index of the first cell??
Thanks for answet
> I have a problem with selecting first cel in selection...Excel XP Pivot Table moves incorrect field to row area
I have a problem that has been frustrating me for a while. I have
built a number of workbooks that use Pivot Tables with an Analysis
Server data source. When I drag a field from the page area to the row
area in the Pivot Table, I occassionally get the wrong field. If I
drag Location Type to the pivot table, location is added. If I drag
financial class, insurance appears. The interesting (and infuriating)
thing in this case is that Insurance was NOT in the page area. It is
an available field in the data source, but had not been added to the
Has anyone else had this occur and ho...Prinding each row of Excel sheet on a seperate page dispallying one record on each pa
From a spread sheet ,I need to print out a row on each page seperately
that is printout each record on the row on one page seperately.
Can any one please advise how it can be done ?
Row 1 Data 11 Data 12 Data 13
Row 2 Data 21 Data 22 Data 23
Row 3 Data 31 Data 32 Data 33
I would want to print out Data 11 and Data 22 on one page
then Data 21 and Data 22 on the second page and data 31 and Data 33
on the third page
Pleae advise if and hwo this is possible.
Message posted from http://www.ExcelForum.com/
Sorry ...Custom Report 03-19-10
There is no way for me to run a report on Buydown Pricing, is there anyone
who has a report for this option?
If not, can someone write a custom report for it, and how much might
something like this run me?
I would like it to do something like buydown quantity greater/less/equal and
same for buydown price...
please contact me at nagarra @ yahoo . com or respond here with your contact
...WLM Stopped working 02-20-10
I'm running Vista Home Premium, SP2, 2 GB of RAM, Firefox, WLM, all WU's
I was in WLM mail newsgroups earlier today and things just stopped. WLM
stopped responding. Now I cannot log into WLM. It used to log into window
Live by itself (password and all) from my desktop icon, but now the only
thing that happens when I try to open my WLM app window is I'm taken to IE
(7). Then when when I try to sign in Windows live it won't do it.
I've already ran SAS, MBAM, CCleaner and Avira in Safe mode but found
nothing. Then I did a system restore back to a fe...Outlook won't let me delete e-mail
I'm using Outlook 2002.
Every time I try to delete an item, it tells me "Errors have been
detected in the file ...outlook.pst. Quit all mail-enable
applications, then use the Inbox Repair Tool."
So I go and use the Inbox Repair Tool, SCANPST. I scan outlook.pst (n
errors come up), re-open Outlook, try to delete an item and get th
same error message.
Can someone help
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
Can you delete them if you hold shift-delet...lookup row number
can you tell me how to lookup the row number of a name in a list.
EG say I have a list of names as below:
I would normally just add a column with the row numbers and then lookup the
row number in the second column but is it possible to do without adding the
extra column by using the row formula someohow?
Try the below..
Jacob (MVP - Excel)
> can you tell me how to lookup the row number of a name in a list.
> EG say I hav...Email server 02-13-10
The smtp outgoing email with VISTA cannot be authenicated.
Vista is not an e-mail client. Please post the error message in its
entirety. You can left click on it to highlight and then right click to
copy and then paste it into this thread.
Imperial Beach, CA
"Charles" <Charles@discussions.microsoft.com> wrote in message
> The smtp outgoing email with VISTA cannot be authenicated.
I had wanted to set up a separate identify to get my work e-mail as Windows
Mail, rather than the webmail from my ISP; didn't know until after completing
the process that Windows Mail combined both personal and work e-mail into one
account. If I "undo" it, popup says I'll lose all of my work e-mail. How can
I save it and undo the dual identities?
Windows Mail doesn't have identities.
You can add multiple accounts, via Tools - Accounts - Add, but Windows Mail
doesn't have identities or a password option.......outbox message will not send or delete
In outbox I have a file with a video clip in windows media. It will not send
and I can not delete. Dialog box says outlook has already begun sending.
thanks for any help
...Context Menu with Bitmaps of Row and Column format
I Want to have a Context menu with bitmaps(not text correspoding to that
bitmap) displayed in Row and Column format , any ideas or links are
appreciated and its just like a Messager "Smilyes" Button where in when i
click on that button it displays some bitmaps in Row and Column format and
please let me know about your sugestions
Thanks and Regards