deleting info within a cell
I would like to delete ' and an s in a set of numbers within a cell how do
you efficently do this through out a data set. (example 344'6s = 3446 in
Find ' and replace with blank, then again with the s
> I would like to delete ' and an s in a set of numbers within a cell how do
> you efficently do this through out a data set. (example 344'6s = 3446 in
> cell only)
do you always have ' and s in your data if yes highlight the data, press
find what enter ', then in replace with don't enter...How do you recover a parameter?
I would like to execute an excel file, for example, with a file name
And afterwards, in that file, I would like to recover the name zz.txt.
Could you please help me?
I'm not sure what you mean by "execute" the Excel file, or "recover the name." It sounds as
though you want to make a txt file from the xls file. If so, you'll need to open it in
Excel, then do File - Save As, with the file type set to txt.
&...outlook xp recovered data - from CD
I just received a CD with all of my recovered outlook xp
data from a failed hard drive: how do I move/copy/transfer
the recovered Calendar, address book and contacts,
personal folders, and emails from the data recovery CD to
my existing Outlook folders? Where does that data reside
on my new hard drive (windows xp pro oper system)? Would
very much appreciate any help. Thanks.
"kevinh" <email@example.com> wrote in message
> I just received a CD with all of my recovered outlook xp
> data from a failed hard drive: ho...Cannot delete Sent Items #2
I can't delete some of the older files from my Sent Items folder. Basically
everything dated 12/7/2004 and earlier will not delete. I get an error
message that says "The messaging interface has returned an unknown error.
If the problem persists, restart Outlook."
I've restarted and still get the same error. I even restarted the computer
Anybody got any ideas?
Are you able to right-click on an individual email and delete it?
Have you tried opening Outlook in safe mode and then deleting the sent items:
http://www.howto-outlook.com/Howt...Recover live calendars?
Someone was helping me cleanup an old laptop and they deleted important
calendars from my WLM. I have months worth of appointments and need some
Thanks (I hope)
Did you sign in to Live services in WLM? It will not say Sign in below the
Close X if you are signed in. calendar.live.com will have the calendars
that will sync back to WLM the next time you connect with WLM.
MS MVP- Windows Live Mail
"nimbus" <firstname.lastname@example.org> wrote in message
> Someone was helping ...Sent messages are not going to the SENT ITEMS folder
When I send messages in Outlook 2000, sent messages are
not going into the Sent Items folder.
I've got the check box set at Tools, Options, E-Mail
Options, Save Copies of Sent Messages in Sent Items
It seems it was working, but not for the past three days.
Any ideas? I'm using Windows XP Home, Office 2000.
...Sending Multi-page e-mails out of Publisher
My wife has a 4-page resume and cover letter that she is trying to send as
one continuous (scrollable) document in an e-mail. So far, we have only been
successful at sending one page at a time.
Does anyone know how we can send the entire 4 pages as one long e-mail? She
thinks she has to reformat it all over again into one large page, but if
there's a way to save doing all that work over again, it'd sure be nice to
know about it.
> Does anyone know how we can send the entire 4 pages as one long e-mail? She
> thinks she has to reforma...HELP!!! Deleting all transactions
I get an error when I try to "delete all transactions" from the
"Store" then "Database" menu. the error says "Could not truncate table
"VitalAuthorization" becase table does not exist in database."
If it's RMS, the table name is VisaNetAuthorizaion, not VitalAuthorization.
<email@example.com> wrote in message
>I get an error when I try to "delete all transactions" from the
> "Store" then "Database" menu. the error says "Could ...Can't delete file in Outlook express outbox
I have a large email file in my outbox that won't send and I can'
PhoenixVPC's Profile: http://www.msusenet.com/member.php?userid=468
View this thread: http://www.msusenet.com/t-187101402
PhoenixVPC, you wrote on Fri, 26 Aug 2005 13:46:14 -0500:
> I have a large email file in my outbox that won't send and I can't
> delete it.
Close Outlook Express and search for the file "Outbox.dbx" on your
system. Delete it an restart OE.
-...Hiding Dbase 111 Records Marked for Deletion
I will be linking several Dbase 111 Tables into a MS Access 2003 Table.
Can records that are marked for deletion be hidden?
I would add a field for Archive - Yes/No. Bring the data in separately and
those marked as 'Delete' set the Archive to Yes.
In your queries use criteria on the Archive field.
Build a little, test a little.
> I will be linking several Dbase 111 Tables into a MS Access 2003 Table.
> Can records that are marked for deletion be hidden?
...Deleting a transaction in Admin
Can someone tell me how to delete a transaction in the admin. Here's the
story, employee helped a customer with a return and ended up oweing the
customer money. Our policy is to give the return on a gift card. the
employee forgot to add a gift card item and just swiped the card on the
tender screen. Since that didn't work she just gave the customer cash back.
Now my x report says that we accepted funds for on a gift card and my cash is
short that amount. I would like to just delete the whole transaction and
redo as if I was giving the customer cash back so all my numbers a...Oulook Internet Mail
I have a user who is only getting the Internet mail option
for outlook and services does not show uip to change it to
the Exchange mode.
which version of outlook? it sounds like you are in internet only mode and
need to reconfigure for corporate - look in tools, options, mail [services]
for the reconfigure button.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Search for answers: htt...Outlook Rules doesn't allow deletion.
Outlook Rule that I ask to permanently delete a message before I even view it
says I don't have appropriate permissions to perform the task. I am the only
user and am listed as administrator. I'm sure you've seen this before and I
think I had it corrected .... once .... before I had to do a full factory
recovery in past months. Would you be kind if you know the answer and direct
me? Thanks a gazillion! XP Outlook 2003 on Toshiba Laptop using Student and
Teacher Edition. Thanks, jack
Jack da Shack
I want to quickly delete unwanted rows from a file. I can use a custom
filter to "hide" the unwanted rows, but I'd like to delete those rows.
Instead of hiding the unwanted rows, filter to show ONLY those rows. Then
select and delete the visible rows.
> I want to quickly delete unwanted rows from a file. I can use a custom
> filter to "hide" the unwanted rows, but I'd like to delete those rows.
> Any suggestions.
You need to choose a filter option which displays only the unwanted
rows (i.e. the oppos...Why is mail merge not available?
I have newly installed Publisher 2003 and most of the mail merge commands are
not available. How do I activate this feature?
What commands are unavailable? Can you open the wizard?
Mary Sauer MS MVP
"MarkCJ" <MarkCJ@discussions.microsoft.com> wrote in message
>I have newly installed Publisher 2003 and most of the mail merge commands are
> not available. How do I activate this feature?
In the Tools/Mail and Catalog Merge ...Recover !!
Ok i updated my old outlook and because it was too much
for my system (like all windows updates) i uninstalled
oulook then reinstalled the old version now i have none of
my old emails and there not in my hotmail either and they
were going into both, hotmail and my outlook ~ so can
anyone help me? or is it lost forever
What is the version of your old Outlook?
Try to search *.pst file
"Robin" <firstname.lastname@example.org> wrote in message
> Ok i updated my old outlook and because it was too much
> for my system (like all windows upda...Unread Mail #4
My Unread mail now shows the deleted folder and the outbox folder,
whereas before and in my other profiles only the inbox folder shows
up. Can I fix this?
Win XP Pro
You can customize the folders that are shown by right clicking and selecting
Customize this Search folder.
<email@example.com> wrote in message
> My Unread mail now shows the deleted folder and the outbox folder,
> whereas before and in my other profiles only the inbox folder shows
> up. Can I fix this?
> Outlook 2003
> Win XP P...Recover Unsaved
I need help. Excel closed without saving what I was working on now I need to
You do not say how Excel closed or what version you are using. The later
versions have an AutoRecover feature.
If you closed Excel without saving the file, you may not be able to recover.
Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
"Tori" <Tori@discussions.microsoft.com> wrote in message
>I need help. Exce...Importing from Mail
Is there a way to import contact card info ( name, home address, e-mail
address, phone number ) into Excel from Apple's Mail ?
Don't know about Apple but most mail programs have some sort of Import/Export
Check out your options to see if you can export the Contacts info as a *.txt
or *.csv file format.
Excel will open either of those.
*.txt files will pop up the Text Import Wizard in Excel, allowing you to parse
your data if need be.
Gord Dibben Excel MVP
On 22 Dec 2005 11:29:36 -0800, "lorrdon" <firstname.lastname@example.org> wrote:
>Is there a way to import co...O/L 2007 deleting valid e-mails
"all of a sudden" (after an update?) my Outlook 2007 has been sending inward
emails apparently at random to 'Deleted' rather than Inbox. In some cases
EVEN IF it's from a trusted address or if it's a reply to an e-mail I've
sent. I can trace no pattern as to why it does so. Junk Mail filter works
100% correctly, however, and Junk ends up in the right place.
Any cure?? Previous thread was inconclusive.
> "all of a sudden" (after an update?) my Outlook 2007 has been sending
...Permanently delete recycle bin give more free space to the server?
I hav a server running NT Server with Exchange 5.5, and set 3 days to delete
permanently all Deleted Items Folders. The info. on Private IS shows deleted
items has been deleted. Why the free space on the server has not increase?
Can I get more free space on the server by deleting permanently Deleted
Thank you in advance.
Deleting items from the database increases the amount of free space in the
database, but does not shrink the DB file. Do do that , you have to take
the daatabase offline and run eseutil...
http://www.microsoft.com/technet/prodtechnol/exchang...Help! I accidentally deleted emails that I desperately need to recover... Any suggestions please?
Desperate here! I have used LACIE back up, does it save emails?
On 1/26/10 10:20 AM, in article C7847266.27FB9email@example.com, "Gavin
Wilding" <firstname.lastname@example.org> wrote:
> Desperate here! I have used LACIE back up, does it save emails?
It depends on what you backed up. Without more details, we can't help.
You can use Switch Identity to access data in a second Identity.
Diane Ross, Microsoft Mac MVP
Entourage Help Page <http://www.entourage.mvps.org/>
Entourage Help Blog <http://blog.entourage.mvps.org/>
YouTalk <...Deleting an exchange 2000 server
Does anyone have any thoughts on how to remove an Exchange 2000 server that
doesnt exist from an Exchange ORG ? I know of a way to remove it using the
ADSI EDit utlity...
Expand Configuration (Server name)-->
CN=configuration,DC=.example,DC=.COM--> CN=Services --> CN=Microsoft
Exchange --> CN=Organization --> CN= Administrative Groups --> CN=(Name of
the RG or Admin Grop) --> CN=Servers --> Rt. Click on the server which you
wannna delete and delete it.
Can I / Should I delete this server from the members in the routing group so
no email gets routed to ...cannot delete text field
I have a shape group with a sub shape that displays one of the parent
shapes custom properties via a custom formula field. I inadvertently
added two of the fields so that now the data is displayed twice. When
I right click on the extra field in the "Insert Field" dialog there
is no drop down menu, just hitting the delete key does nothing. In
the shape sheet when I select the corresponding row the delete option
on the drop down menu is grayed out?
How do I delete this field?
Hey Guy don't abuse of the fresh beer when working on Visio (Dont be angry
If...Mail stuck in outbox, can't delete,won't send, retards send/rec.
I recently scanned 6 pages of text to e-mail, I was asked about the format,
it was .bmp, a mistake as it then attached the .bmp to the e-mail taking 84
mb of memory. Once I noticed this after beginning send I attempted to abort
the send. It stopped the send. Next I tried deleting, couldn't do that as
the message appeared "can't open, Outlook has begun sending". Well, it
really wasn't as I went to bed and awoke to find it still in my outbox.
Tried sending again, same result.
Next I tried to delete, no luck, tried dragging to delete folder, no luck.