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" <firstname.lastname@example.org> wrote in message
> I just received a CD with all of my recovered outlook xp
> data from a failed hard drive: ho...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.
...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...Can't view files with latest beta2 refresh #2
I downloaded the latest Beta2 refresh and now I cant access any of my word
and publisher docs. It says "can't find file" or some such thing. I thought I
read somewhere that the view and print functions in the latest refresh have
been disabled. This is MOST inconvenient as every piece of business on my
hard drive is now useless....is there any way of fixing this?
Yes, you've said that already.
MVP Microsoft [Publisher]
"Fabman" <Fabman@discussions.microsoft.com> wrote in message
news:D9FD0DA9-F0DF-4CFF-ACB9-8207333DEBE7@microsoft.co...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" <email@example.com> wrote in message
> Someone was helping ...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.
<firstname.lastname@example.org> 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.
-...After catalog merge where items are different heights...
It would be nice if I could get the text boxes to 'autoflow' or snap together
when I resize textboxes. In other words, after a catalog merge, some
descriptions are shorter than others. So, when I go to one of the short
descriptions and shrink the height of its textbox, I am left with a big gap.
Any way to have the following textboxes snap up to the bottom of the previous
textbox? This would seem to be a serious shortcoming of Publisher. In HTML,
for instance, DIVs stack on top of each other.
The other option would be to allow the catalog merge to spew the entire
formatted conte...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...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?
...Bills summary balance missing #2
In Money 2005, the Bills Summary screen contained a balance that would
update based on the selected bill(s). In Money 2006, this balance no longer
appears. Does anyone know why this may have gone away or how to re-enable
I am thinking this might have to do with a new feature of Money 2006 ("New!
Manage bills easily. Money 2006 Deluxe allows you to pay multiple bills from
multiple accounts all at once"). That's nice, but what about folks who pay
bills from just one account--say, a checking account? There is a link to
"View current balances" that shows bal...Excel
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...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
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" <email@example.com> wrote in message
> Ok i updated my old outlook and because it was too much
> for my system (like all windows upda...get number of monday, tuesday,... between 2 dates
Hi, how can I get number of monday, tuesday,... between 2 dates?
Racsus (Racsus@discussions.microsoft.com) writes:
> Hi, how can I get number of monday, tuesday,... between 2 dates?
DECLARE @offset int,
SELECT @day = 'Tuesday'
SELECT @offset = CASE @day
WHEN 'Monday' THEN 1
WHEN 'Tuesday' THEN 2
WHEN 'Mittwoch' THEN 3
WHEN 'Thursday' THEN 4
WHEN 'Friday' THEN 5
...Risk and Decision Analysis @Risk, Evolver, Decisiontools, Roy Kelly FloorTrader Tools 8.3, AmiBroker 5.0, MultiCharts 2.1, NinjaTrader 6, OwnData 2.6, VantagePoint 188.8.131.52, other ...
Risk and Decision Analysis @Risk, Evolver, Decisiontools, Roy Kelly
FloorTrader Tools 8.3, AmiBroker 5.0, MultiCharts 2.1, NinjaTrader 6,
OwnData 2.6, VantagePoint 184.108.40.206, other ...
please send e-mail to : ola 'AT' mail 'DOT' gr , ola3 'AT' mailbox
'DOT' gr , ( please substitute 'AT' with '@' , and 'DOT' with '.' ) ,
RISK ANALYSIS with @RISK
@RISK 4.5.7 for Excel, Compatible with Excel 2007, ( Standard,
Porfessional, Industrial )
@RISK 4.5.6 Internat...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...Restore Issue #2
Having a problem restoring a database backed up with NT backup. The error I
keep getting is:
Failed to find a database to restore to from the Microsoft Active Directory.
Storage Group specified on the backup media is
Database specified on backup media is Mailbox Store3 (EXCH-1), error is
The backup media is obviously seeing the name incorrectly. How can i correct
What should the db name be? Have you tested backups before because the
backup may be corrupt.
"JS" <firstname.lastname@example.org> wrote in...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
...Landed Costs #2
Does anyone know how to enter a landed cost for a shipment receipt. I
have entered landed costs and assigned them to items but cannot enter
them in the receiving window (POP). The help says to use the Receivings
Landed Cost entry window, but I can't find it. Can anyone help?
I have a word document that outlines the transaction flow for landed cost.
Perhaps that will help answer your question. If you are interested, let me
know and I'll email it to you.
Microsoft MVP - GreatPlains
"JO" <email@example.com> wrote in message
news:11...The best club for muslims all over the world!Have a try!! #2
The best club for muslims all over the world!Have a try!!
...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.27FB9firstname.lastname@example.org, "Gavin
Wilding" <email@example.com> 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/>