2015 was a good year

I have been blogging from here for the past 8 years and I have a great audience. This year has been a very good year if I go by the number of posts.

The audience is world wide and I hope I have been able to help some. I feel good, if I can help someone who is beginning to do things from some corner of this earth which is further away from the hub of things.

December 2015 views curtsey of ClusterMaps.com

Technology changes very fast, to keep pace with changing technology is not always easy. Hardware, software, and platforms change very fast and it is impossible to track these changes easily. New languages and new paradims are created like almost everyday. Help of any kind is welcome. It is to provide this help this blog was created.

HodentekHelp wishes you all a very happy and productive New Year. May your wishes come true.

2014 was a mixed year

2014 was a mixed year. I lost my brother Dr. Vijaya Raghavan Krishnaswamy, a neuro-surgeon by profession. He left a void that cannot be filled.

I did not complete the book I was writing.

Regarding the blogs I did quite well with a record number of posts.
                                                 Year   Posts
Hodentek.blogspot.com           2013   94
                                                 2014   246

HodentekHelp.blogspot.com.  2013.  17
                                                 2014   56

HodentekMsss.blogspot.com   2013   34
                                                  2014  48
 
HoentekMobile.blogspot.com  2013   13
                                                  2014  

I started a new blog in 2014- http://hodentekPlus.blogspot.com.

I also found that a certain person was pilfering (http://hodentek.blogspot.in/2014/12/domain-name-service-dns-and-dns-changer.html) entire content from blog, my hardwork of about 10 years. I complained to Google without any success. I suppose this is not on Google's priority. Google wants every post that is stolen with proof of content stolen. There were over 900 posts in my blog and you can imagine the work involved.
 

How do you import a text file to MS EXCEL 2010?

Text file should have some delimiting characters such as comma, tab, etc. Here we assume comma as the delimiting character.

Step 1:

Download the file to a location of your choice, say C:\

Or

Click to VIEW the attachment. Select all in the view. Open Notepad and paste the selected items to Notepad.

Save the Notepad with the selection pasted to a location of your choice, say C:\. Use the file name PrincetonTemp. It will be saved with the extension .txt.

If you cannot complete Step 1 go to the end of this post.

Step 2:

Open a new EXCEL workbook.

Step 3:

Click the menu item DATA at the top.

Step 4:

Now Click the item From Text.

This opens the Import Text File window. Now you go to the location where you saved the file.

In my case it is on the Desktop in a folderr called Basic Excel Training as shown above.

Step 5:

Click PrincetonTemp in the window above and click the button Import at the bottom.

Step 1 of 3 of the Text Import Wizard is displayed as shown.

Note 1: You can see the location of your file here

Note 2: You can see part of your data.

Step 6:

Click the Next button at the bottom.

The Step 2 of 3 of the Text Import Wizard is displayed as shown above.

Since your file has (,) comma delimited. Place a check mark in the check box named  ‘Comma’ as shown below.

Notice that when you click in the box ‘Comma’, you will see the preview of your data as shown above. You are almost there!

Step 7:

Click the button ‘Next’.

Step 3 of 3 of Text Import Wizard is displayed. Here you can make changes to the data and format it. For now Just click Finish at the bottom of the screen.

The Import Data screen is displayed as shown:

If you now click OK, the Excel program will paste the imported data beginning in cell A1.

 You can post it to another location or to a new worksheet. For this exmaple let us just click OK.

The data is imported to the worksheet as shown here.

That completes the Import Process.

---------------------------------------------------

If you could not download the file from my email to you, here it is, just copy and paste it to Notepad

January, 40, 60

February, 32, 50

March, 43, 65
April, 50, 70
May, 53, 74
June, 60, 78
July, 68, 70
August, 71, 70
September, 60, 82
October, 55, 67
November, 45, 55

December, 40, 62