Extracting E-Mail addresses from a file or a web page using Microsoft Excel

Recently I needed to extract E-mail addresses from a range of cells in an Excel file. I looked around for a solution on Internet.

After going through number of solutions, I hit upon a very elegant solution that could be used easily for extracting Email addresses not only from Excel file but from any web page or a word file or anything that can be selected and copied and pasted in to a Excel sheet. The solution is described below.

It's essentially a short VBA (Visual Basic for Applications) code (also called a program) to create a custom function in Excel named FindEmailAddresses(Cell1:Cell2). Where range Cell1:Cell2 would contain the text from where we wish to extract Email addresses.

Assuming we have already created the function (explained later below) - here is a description of how to use it.
1. Assuming cells A1 to C5 contains the text from where we want to extract email ids
2. Insert a new column at A1 - so that original content of A1 to C5 will shift to B1 to D5.
3. Now, select Cells A1 to A4 - where the extracted Email ids would come. Here, we are selecting only 4 rows because we know that number of extracted Email ids will be less than 4. If they are more then select more number of rows.
4. While keeping the selection, in Cell A1 type the function =FindEmailAddresses(B1:D5), as shown below.
5. Now press Ctrl + Shift + Enter. Note that this step is crucial. By doing this, formula in A1 will get copied to all cells up to A4.

	A	B	C	D
1	=FindEmailAddresses(B1:C5)	Hello world	Well just a empty cell	Nothing here
2	=FindEmailAddresses(B1:C5)	There is no email here	There is an email id:prakash@gmail.com	Here also nothing
3	=FindEmailAddresses(B1:C5)	Excel is very good tool	Practically this is useless
4	=FindEmailAddresses(B1:C5)	Her email is meena@yahoo.com but it changed	Nothing here	Well this Is good
5		Nothing		Theoretically this is empty

You will the extracted Email ids from B1:D5 in A1:A4 as shown below.
 

	A	B	C	D
1	prakash@gmail.com	Hello world	Well just a empty cell	Nothing here
2	meena@yahoo.com	There is no email here	There is an email id:prakash@gmail.com	Here also nothing
3	#NA	Excel is very good tool	Practically this is useless
4	#NA	Her email is meena@yahoo.com but it changed	Nothing here	Well this Is good
5		Nothing		Theoretically this is empty

If all cells A1:A4 shows #VALUE! then save the file and upon opening the file you will see a warning saying 'Macros are disabled' Click on 'Enable Macro' and you will see the Emails ids in A1 to A4. If number of Email ids are less than 4 then you will see #NA in remaining cells. If they are more then select A1:A4 and press 'Del' key. Now, select more number of cells in step-3 above and continue. 
 
Note that if the range B1:D5 has only one Email id then all cells A1:A4 gets filled up with same Email id.

How do I extract Email addresses from my Gmail or Outlook application?
Well, this technique can be used only for extracting Email addresses from a single page. If you wish to extract Email addresses from your Email application - you will have to get programs that are developed specifically to do this work.

How to add user defined function FindEmailAddresses
Before you can use above function, you will have to add the user defined function using following procedure in Excel. It works with all versions of Excel from 2003 to 2013.

1. Press Alt-F11 to open Visual Basic editor (while you are in the file containing the Email addresses)
2. On top menu under Insert click on Module.
3. Copy and paste the user defined function (given below) into new module window.
4. Exit Visual Basic editor by clicking on 'x'
5. Use the FindEmailAddresses function in Excel file, as explained above.

Visual Basic for Applications (VBA) Code:

Copy and Paste following code (program) in Visual Basic editor of Excel.
-----------------------------------------
Function FindEmailAddresses(rng As Range) As Variant()
Dim Temp As String, Cell As Range, EM() As Variant
ReDim EM(0)
For Each Cell In rng
Temp = Cell.Value
Do While InStr(Temp, "@")
   EM(UBound(EM)) = GetEmailAddress(Temp)
   Temp = Replace(Temp, "@", "", 1, 1)
   ReDim Preserve EM(UBound(EM) + 1)
   Loop
Next
ReDim Preserve EM(UBound(EM) - 1)
FindEmailAddresses = WorksheetFunction.Transpose(EM)
End Function

Function GetEmailAddress(ByVal S As String) As String
Dim x As Long, AtSign As Long
Dim Locale As String, DomainPart As String
Locale = "[A-Za-z0-9.!#$%&'*/=?^_`{|}~+-]"
Domain = "[A-Za-z0-9._-]"
AtSign = InStr(S, "@")
For x = AtSign To 1 Step -1
    If Not Mid(" " & S, x, 1) Like Locale Then
       S = Mid(S, x)
    If Left(S, 1) = "." Then S = Mid(S, 2)
       Exit For
    End If
Next x
AtSign = InStr(S, "@")
For x = AtSign + 1 To Len(S) + 1
    If Not Mid(S & " ", x, 1) Like Domain Then
       S = Left(S, x - 1)
    If Right(S, 1) = "." Then S = Left(S, Len(S) - 1)
       GetEmailAddress = S
       Exit For
    End If
Next x
End Function
----------------------------------------
Explanatory Notes
This notes are for those who wants to know more about technique used in this solution and further improvements.
1.  VBA code uses simple string comparison to find out presence of @ within the content of a cell. If it found one it found out word before and after it and extracted it as a Email address. This is done in GetEmailAddress function
2. It uses a clever Array Formula technique to store the extracted Email addresses one each in each cell. This is done by Ctrl+Shift+Enter key combination.
3. With some modifications this technique can be used to sort the extracted Email address domain wise (@yourcompany.com).

If you find it useful or have any suggestions - do write back.

Would you ditch a PC running Windows XP because Microsoft is stopping support from April 8, 2014?

For last 6 months or so there is an intense debate and advisory from various sections of media, some of them acting on behalf of certain IT vendors also, that it would owe fully dangerous to continue to use Windows XP PC after the D-day.

Here is my insight in to the situation:

Windows XP has been in existence for last 12 years. This period is perhaps longer than any other Windows version so far. And also, it is one of the most admired and widely use PC operating system on earth. Even as on today, more than 30% of PCs run Windows XP.

So, should people scrap the PC or donate it to a charity or do something else?

There have been various answers from various people. Some of the most popular are listed below:

1.Upgrade it to Windows 8.1: Well, this may not be possible for most of the PCs because of old hardware or cost of upgrade. In fact, cost of upgrade is perhaps more than double of the current value of the PC.

2. Upgrade to Windows 7: If we decide to ignore the cost of Upgrade then this may be possible to do. But, key question is why should one put in money to keep running a dying hardware? It could be that application running on the PC is not upgraded for Windows 8 and it's mission critical to keep them running, as long as it is possible.

Well, this is easier said than done because there is no 'in-place' upgrade possible from XP to Windows 7. So, one has to use various tools provided by Microsoft to chart out the upgrade plan. This is a long and time consuming path; but there is hardly any option. There are some vendors who claim that they are able to make it easier if you agree to 'buy' their solution. Well, if you have enough money one can try it. But, in practice, no one has that much money.

Once done, one can run the mission critical application on Windows XP mode of Windows 7. So, this is doable but very costly in terms of money, time and effort. And no one is sure how long the PC will last. It may die sooner than you thought was possible; or a part can fail for which no replacement is available - coming back to 'almost dead' situation.

3. Run Windows XP on a Linux Virtual machine: Well this approach is not for the people with weak heart. Robolinux claims to provide one click install of Windows XP on top of Robolinux. This is possible to do provided you have a good hardware i.e., it should have enough memory and a processor capable to run a virtual machine.

So, this approach is ruled out for people who are running Windows XP on a old processor or with say 256 or 512 MB memory.

Assuming this is not a problem, but tell me what's benefit of doing this? Well, it is claimed that if Windows XP is running on top of a Linux OS then one would be saved from the antivirus and antimalware because it is running on top of a Linux - which is by default very secure. I doubt this claim unless one wants to run Windows XP in isolation i.e., it won't connect to Internet at all. If it is then one would require all security gears to protect itself from all kinds of attacks. It's like a baby dying within a iron cage.

Also, making this work requires major work in terms of first formatting the existing hard disk or getting a new one. First install Robolinux on it. Then donate the developers to get One Click virtual machine install for Windows XP. Then install Windows XP, install the required applications, update the XP with all patches and so on. Too much of a work for the promise of no viruses - a claim which itself seems doubtful if one is going to connect to Internet.

4. Switch to Linux: Well this topic requires lot of work on part of the user. In most cases small and medium business owner is not able to do this himself. It requires hiring of a Linux consultant, at least for couple of months to start with; and subsequently on a call basis for migration, user training and technical support. It's not easy or cheap to do this. Also, there is no Linux distribution worth its name who is as even close to Microsoft Windows as a Desktop Operating System. Of course, many are trying for a long time - and I've tried many of them and have given up for various reasons.

Notable among them are Ubuntu, Mint with Cinnamon and there are many of them out there. None of them come closer to Windows for following reasons:

a. Usability: Some basis short cuts that Windows user use on a regular basis do not work in Linux viz., Alt+Arrow keys to Select text, Ctrl+Alt+Del to reboot a hung PC (even Linux hangs, believe me) and so on. Also, Libre Office is a disappointment compared to Microsoft Office on a ongoing basis. I have tried using Libre Office and its earlier avatar a number of times but each time I've given up for some reason or other. It simply does not measure up on various counts e.g., speed of execution, office file compatibility, formatting, absence of key features etc. etc. etc.

b. Poor Design of Linux applications: Say one is using Lotus Notes Mail client in FireFox - it seems to work properly. But, moment you try to attach a file that is not on the local PC you are out of luck. It just can't attach a file that is located on Windows or Linux (Samba) server. File Manager does not remember Samba shares. It is not able to display directory structure in a way similar to Windows File Manager. Fonts and color schemes look poor - challenging not only aesthetic sense but also wasting precious space on the screen. Wine is able to run Windows applications but if that Window application wants to access files on Windows Server or Linux (Samba) server - you are out of luck.

Of course, if I don't mention this I will be doing injustice to Linux community. Linux has evolved by leaps and bounds in last 5 to 7 years. So many features have been added - making it almost as good as Windows, feature wise or hardware support wise. But, it simply lacks finesse or ease of doing work. There is an immediate drop of productivity (even after a good Linux training). 

One notable Linux distribution from India which seems to offer alternative to Windows XP users is named Tiguin - Tiger and Penguin together in one body. Well, I must say that it's a good effort, particularly coming from a small town of Gujarat. I gave it a decent try and it is still installed on my Windows XP machine as a dual boot. Installation is almost flow-less - I would give more than 90% mark for installation. It's a distribution targeted to small and medium businesses of India. It offers all frequently used application under Windows on a Linux  For those application which are available only on Windows like Tally (accounting software) and Microsoft Excel (required for Tally to do export reports in Excel format) it offer them either out of the box or easy installation without end user to learn complex Linux commands. In summary it makes Linux as close to Windows XP as is possible. It works on subscription model for updates and technical support. I tried taking their help for few technical problems I faced but it was average i.e., nothing great.

In few areas in spite of its best foot forward it is not able to come closer to Windows because of inherent limitations of Linux mentioned above. Also, one shortcoming I noticed is that out of the box it uses old version of FireFox (22 against current 27), Libre Office and so on. Upon inquiry Enjay (developer of Tiguin) said they have chose 'stable' versions over 'current' versions. Well, I don't agree with this.

5. Switch to a Windows XP clone: This is a little known fact but indeed there is an open source project that has been trying to write an almost exact clone of Windows XP. It's called React Operating System. Many people are working on it. It's specs are quite close to Windows XP. Few alpha versions are available for trial but sadly it is advancing very slowly for want of funds, I suppose. I've downloaded version 0.3.1.6. Its live CD did not work on few PCs I tried. Version 0.4 (community edition) is likely come out very soon. How soon? No body knows. But, there is some hope that after say one year something credible may come out. Keep hoping.

Is there any way out for Windows XP users?
Yes, and it is very simple. Keep using Windows XP as long as hardware keeps working.

Why am I saying this?

First, Windows XP has hardened itself in last twelve years. It's very stable, usable and very secure. And there is no reason (at least today) to ditch it in favour of something else in a hurry.

My guess is that we can make it work at least till end of PC's life. By no stretch of imagination this period would go beyond 3 years - on average of course.

Microsoft will keep supplying updates to its own antivirus Microsoft Security Essentials till July 2015. Avast has announced that they will provide support to Windows XP at least for three years. See official text below from Avast.
--------
Are you aware that AVAST will be supporting Windows XP for at least the next three years, by creating protection modules and detections specifically designed to cover Windows XP vulnerabilities and other security problems? (We will be doing this!)
--------

So, why worry or hurry now? There is no need to open wallet and make payment to buy new PC or purchase Windows 7 or 8.1 and of course, new Office 2013 and so on.

What do you say?

Review of Windows Phone 8 - Nokia Lumia 720

I used Blackberry 8310 smartphone for five years before buying Lumia 720 in May 2013. Not that I was unhappy with its usage or performance, but it had started showing signs of aging. Also, I craved for bigger font size due to slight deterioration of my eye sight with age; and of course, I wanted Wi-Fi support to save money on data charges.

So, I decided to purchase a new phone. Without much thinking, I thought of purchasing Windows 8 Phone, naively thinking that since it is from Microsoft and it includes Office, it would be able to open and edit Microsoft Office files without any problem. And, to my utter surprise this assumption turned out to be true,  only partially, though. Read on to know more.

Also, another reason was that most of resellers of packaged software had switched to Windows Phone, possibly for the same reason. But, now I find that, many of them feel that they will have to wait for another service pack before they can get a reasonably good smartphone.

Good things about Microsoft (and Nokia) Lumia Windows Phone 8
First I will say what I like about this phone. Most of it is hardware; and some software.

It has a large screen size (4.3") with very good touch quality. In fact, its normal touch is so sensitive that many a times when I'm talking on the phone, my ear accidentally turns 'on' the Mute / Speaker button on the screen!  In such an eventuality i.e., when the other party starts saying 'hello, hello' or when every one around me starts hearing what is being discussed, I sheepishly look at my phone and press the Mute/Speaker button to put it off. I wonder, if this happens on any other touch phones.I checked with few android and iPhone users and their answer was that it does not happen. So, Microsoft, please pay attention to such small details in your software. It goes a long way to create your reputation.

Its build quality is very good, as usual for Nokia. Its sound quality is very good; with very good quality camera pictures even in low light conditions. It has 6.1 MP camera with Carl Zeiss lens and LED flash. In fact, I find photos taken with built-in flash of poor quality. In fact, so bad that I've deleted almost all of them from my phone. Its 720p video recording is of good quality.

Live Tiles

 Its live tiles are good; visually telling if any attention is required. Also, I like the time-display on locked screen, which came with the Amber update. But, I sorely miss my Blackberry's red/orange/green LED light and different sounds telling me that new Email/Message has arrived.

Search on Server

One feature I like the most is its ability to search messages on the server. What I mean is, say you wish to search for a mail and you don't find it on the phone; then you can click on 'search on the server' and get the required message. I have found it life saving; and this feature was not there on my Blackberry 8310 (it could search only on the messages stored on the phone). I love it. Of course, in all fairness, I notice that search results are not accurate. I've tried to search for certain message in the mail box and I could not find it; though later on I could find it on the server using PC's web client software.

History in Contacts

Another feature that I like about Windows Phone is its ability to link contacts from multiple sources. For example, after you have configured various Email and Social media accounts on the phone, it automatically pulls out contacts from outlook.com / hotmail contacts, google contacts, facebook, linkedin, twitter etc. If name and contacts match then it automatically links them to a single contact. Of course, if names of few contacts are same then one is required to unlink them manually.

This feature extends beyond linking contacts. When you choose a contact, upon swiping to right side, you see history of Emails, Phone calls and Messages (SMS, Facebook messages) with that contact.

Also, I like the one line notification that comes on top of the Windows Phone screen (no matter what app you are in) for the incoming Messages (SMS, Whatsapp, Facebook).

Ability to automatically backup set-up and photos etc on cloud is a life saver.

What I wish Microsoft would improve in Windows Phone 8 in the next update
What I don't like or what makes me scream or pull out my hair is in this part.

Any way, first problem I faced was when I tried to copy contacts from Blackberry. Both phones would pair using Bluetooth and transfer few contacts; but would invariably fail after some time, no matter what I do. So, I thought, if I transfer the Blackberry contacts to Microsoft Outlook it should work because Windows Phone would directly get the contacts from the outlook on the PC. But, no. I was wrong. There is no simple way to transfer contacts to the Windows Phone. I had to create a outlook.com mail account, create alias of my work email id, export outlook contact list to an excel file and import it on outlook's mail account. This worked after some frustrating moments. Thank god and Microsoft, of course.

Actually, I find that list of features that I wish were there is simply too big. So, I've listed it below with some short explanations.

Wish List

• Basic Phone Features
  It is rather sad to note that in the race to become leader in the smartphone operating system Microsoft forgot to incorporate certain basic features which are essential for the phone users. I feel very sorry to have to write about it here.
• Call duration of incoming and outgoing calls. Here what happens is that when phone is disconnected, it shows the call duration. And, after that it just disappears from the phone. So, if you are trying to find out with which number you spoke to for say 30 minutes - you have to be plain lucky to find that number.
• How about keeping track of cost of the calls made? Forget about it. Microsoft assumes that all users are super rich.
• Ability to know from which number a caller called - when the caller is already there in the contact list. In the call history, phone shows caller name and words mobile/work/home etc. But, when multiple numbers are listed under mobile/work/home then it is not possible to know from which number caller called. For example see picture of 'History in Contacts' above.
• Messaging app does not show number of characters typed. It is important to know this to limit because if number of characters go beyond 160 characters, mobile operator charges for multiple SMSs.
• It should be possible to send SMS on any number listed in the Contact list. Currently, when a contact has two mobile numbers (Mobile and Mobile 2) and we click on Text/SMS - Microsoft only knows to which number the SMS has gone. Suppose we want to send SMS through Mobile2 then there is no option.
  
  
• Reliability
• Ability to store typed messages even when incoming phone comes. While writing mail if incoming call is attended typed text is lost some times. It is supposed to get saved automatically to draft folder but it does not happen every time.
• Ability to forward mail attachments reliably. Some times, when a mail is forwarded, attachment doesn't reach the recipient.
• Better reliability as far as its normal usage is concerned. Well, this complaint is not new to the users of Windows OS on a PC. But, Microsoft is carrying forward same legacy to Windows Phone also.
  
  Twice, suddenly, for no rhyme or reason, my phone stopped displaying anything on the screen. If I dialed it from other phone the ringer would not ring but it would vibrate. I thought, this phone has gone nuts. Surely it requires a Nokia Service Centre visit. And worst part was that I was in Hyderabad on some important work and I had not carried my laptop. So, I had to made it work as early as possible. Fortunately I had another phone and I called up a friend. He told me to use old time Windows CAD trick i.e., we press Ctrl, Alt and Del key together. He explained that on Windows Phone, we have to press Vol- (minus), Power and Camera keys together; and hold it there for 10-15 seconds. It worked.
  
  Even today morning, when I typed in a message on Whatsapp and pressed send button, phone suddenly rebooted with 'Nokia' and 'Windows Phone' messages. Fortunately when it came alive, it was back to normal, except that I had to type the message again on Whatsapp and send.
  
• Storage  
• Apps should be able to read/write document files stored on the SD card. It is rather sad to note that this feature has been available on Blackberry and Android phone for more than 4 years now; and it is sadly missing on Windows Phone. Of course, one can copy document files to the SD card on 'Document' folder using Windows 8 PC and later open it on the phone.
  Of course, apps can't be stored on the SD card, thus limiting ability to store apps and documents on the phone severely.
• When I upgraded to Amber, I had to uninstall several apps to make space for the installation. Out of which Amber Update size was 1.1 gb and it required 2.2 gb free space to download the update file and do the installation.
  Currently, out of 8 gb phone space, only 7.2 is available for users. 1.9 gb is taken by apps, 1.5 gb is taken by media & files (I haven't stored a single photo/video on phone), operating system is taking up 1.9 gb and 1.9 gb is free.
• Better way to delete a downloaded Nokia map. If you wish to delete a map of say 250 mb you would require 500 mb free space on the phone. This is absolutely counter intuitive to our common sense. In fact, reason for deleting a map is that we are out of space and want to create more space; and if deletion itself requires double free space the how does one delete a downloaded map?
   
• Smartphone Features
• Ability to see history and address book in landscape mode.
• Improved editing features. Very poor compared to my old Blackberry phone.
• Search - by phone number - Remember search history
• Partial text Copy and paste from messages.
• Language keyboard for all major languages of India. Hindi language keyboard is currently there.
• Flash Player Support.
• There should be a better way to close open Apps. Currently, apps can be closed only using back button. 
• Ability to record phone conversations. This could be done in Windows Phone 7 but not now. For security reasons (!) this feature is removed. There are times, when some important discussion is taking place on phone, we want to record it. We are able to record our land line telephone calls. Isn't it?
• Find My Phone support for users in India. This feature is helpful if you loose your phone. It works by alerting you on the alternate number when SIM card is changed. It can ring, lock, erase, locate or send apps to your phone from WindowsPhone.com.
• Better SMS and call blocker. Currently it is blocking SMS' from my banks and mutual funds - although I have not blocked them. I believe origin of this problem is SMS Short Codes eg.LM-Citibk, LM-VIDDTH, MD-ICICIB, LM-SNAPDL etc  Surprising all such SMS show sender no as 00...(10 zeros). In blocked Nos I have unblocked 00.. but still SMS lands in blocked SMS.
• Internet Explorer 10
• Remember History, Import Bookmarks 
• IE should have forward button. 
• IE windows can be closed only by hitting back button as many times as one has gone forward.

• Email
• Ability to attach documents on phone while replying or forwarding E-Mails. I can't believe still that this I can't do on Windows Phone.
• Option to keep mails on server. What happens is that if I delete a mail on phone, it gets deleted from the server. I've lost several mails due to this implementation because I'm used to deleting not-needed or already answered mails from my old blackberry phone.
• When multiple attachments have same file name, only one attachment file is copied to all other.
• Some times attachment don't come on Windows Phone Email or get forwarded to the recipient.
• While writing mail if incoming call is attended, typed text is lost some times.
• Better Email Client app. Mails with subject line more than 64 chars in Gmail when replied or forwarded screws up the mail. The mail recipient sees malformed message viz., mime header in the beginning of message (with few words before the header from the actual message). In short, mail recipient ends up thinking that I'm using some arcane or obscure mail client that leads this crazy mess. This is a known problem that has not been resolved yet.
  
  Sample of replied mail with subject more than 64 characters in Gmail account:
  ---------------
  Mumbai
  MIME-Version: 1.0
  Content-Type: multipart/alternative;
          boundary="B_3464886549_7950253"
  > This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.
  --B_3464886549_7950253
  Content-Type: text/plain; charset="utf-8"
  Content-Transfer-Encoding: quoted-printable 
  Dear Sir,
  
  Need your help to locate an article.
  .....
  ----------------
• Some times, some mails without any reason (including one mentioned above for Gmail with more than 64 char in subject line) comes with garbled message. See example of mail received in my outlook.com mail account.
  
  --------- malformed message on phone ------
  Subject: RE: SSL re-issue
  --_000_
  6A0B791EFB91774596BDE725416B567BD1798ENMMUMEXCHMBX01net_
  Content-Type: text/plain; charset="utf-8"
  Content-Transfer-Encoding: base64
  
  RGVhciBSYWplc2gsDQoNCkkgdW5kZXJzdGFuZCB0aGF0IHRoZXJlIGlzIG1pc3Rha2Ugd2hpY2gg
  aGFzIGhhcHBlbmVkLiBDdXN0b21lciB3YXMgbm90IHVzZWQgdG8gd2l0aCB0aGUgcG9ydGFsIHNl
  Y29uZCB0aGluZyBhcyBhIHNlY3VyaXR5IHBvbGljeSB3ZSBkbyBub3QgZXhlY3V0ZSAvIG1hbmFn...[message truncated]
  
  ------- actual message is given below ----
  Subject: RE: SSL re-issue
  Importance: High
  
  Dear Rajesh,
  
  I understand that there is mistake which has happened. Customer was not used to with the portal second thing as a security policy we do not execute / manage on behalf of customer. So there has to be a policy / mechanism to rectify the mistake.
  
  If customer doesn’t like the service....[message truncated]

Word - Format Options

Excel - Format Options

• Office for Windows Phone:
  This is the greatest let down of the Microsoft Windows Phone. At best, it is a very basic Office app. Most of the features are missing. At many places only icons are put without even text to explain what it is supposed to do; and no help feature either. See screenshots of Word and Excel Format Options. This app seems to be developed by school boys.
• Missing Features in Office
• Ability to open certain types of Office 2007/2010/2013 files e.g., xlsb files
• Ability to edit Office 2003 files e.g., doc, xls, ppt
• Ability to create new PowerPoint files
• Ability to Copy and Paste with Formulas, Format, Copy Down etc.
• Ability to open password protected documents
• New file creation option in the front menu
• Many more features to edit and format files.
• Help for each office features.
• Apps
• App for Virtual Private Network (VPN) connectivity.
• App to securely store all types of passwords.
• Banking app support e.g., Citibank, ICICI Bank.
• PDF reader should be able to word wrap the text. I very badly miss this feature from my Blackberry's PDF to Go app. It is very useful for reading ebooks in PDF format.

After Amber update, a feature was added, where if I don't want to pick-up an incoming phone, I just turn the phone upside down. While, I've loved this features, I find a few times that if phone is in the trouser's pocket, it does not ring i.e., when I take out the phone - I find some missed calls. Also, a few times, people say that I re-dialed them number of times. I believe, this did not happen before the Amber update. So, this strange behavior must be result of bad design.

I wish to hear your comments, experience of Windows Phone 7 & 8.

-oOo-