Search This Blog

Search Engine

Custom Search

20100627

Night Trains after 9 PM from Kalyan to Pune

Trains after 9 PM from Kalyan to Pune

Train No. 1333+1329+1327 - Shirdi Fast Passenger, BB Bijapur Fast passenger & Fast Passenger
Starts at 23.55 from Kalyan
& reaches Pune in 4.15 hours@ 4.10 AM

Train No. 1005-CSTM Latur express
Starts at 21.50 from Kalyan
& reaches Pune at 00.50 AM in 3 hrs.

Train No. 2163-Chennai Express
Starts at 21.15 from Kalyan
& reaches Pune at 00.05 AM in 2 hrs. 50 min.

Train No. 1017-Chalukya Express
Starts at 22.15 from Kalyan
& reaches Pune at 01.00 AM in 2 hrs. 45 min

Train No. 1035-Sharavati Express
Starts at 22.15 from Kalyan
& reaches Pune at 1.00 AM in 2 hrs. 45 min.

Train No. 1013-Coimbatore Express
Starts at 23.18 from Kalyan
& reaches Pune at 1.55 AM in 2 hrs. 37 min

Train No. 2115-Siddheshwar Express
Starts at 23.35 from Kalyan
& reaches Pune at 2.10 AM in 2 hrs. 35 min

Train No. 1011-Mahalaxmi Express
Starts at 21.30 from Kalyan
& reaches Pune at 2.10 AM in 2 hrs. 35 min

20100608

How to remove spacings in text in excel?

CLEAN & TRIM FORMULA

Clean formula is used to remove space & nonprintable characters from text which is majorly imported from other systems.

But 1 or 2 etc. spacings created after writing a word bcos of which vlookup does not work can not be corrected by Clean Formula. We need to go for Trim formula for this

Clean formula
=Clean(C1) where c1 is text to be cleaned

Trim formula
=Trim(c1) where C1 is text to be trimmed

To trim means to remove unwanted spaces either between the text or at end or beginning of text

So space created bcos of Alt+Enter is removed by Clean formula but one or two spacings can not be removed by Clean formula. We need to use Trim formula for the same.

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

20100607

Google Desktop Search

Google Desktop Search
Download Link - google-desktop.en.lo4d.com/download/mirror-ex1
Present status - Discontinued by developer but still preferred to use by a lot of users inspite of shortcomings


Use Google desktop search button as 2nd option to find out lost files in PC if Microsoft search

buttons cannot find those files.

In finding files from PC - Microsoft search button is superior to Google desktop bcos display of

files is more convenient in Microsoft search button whereas in google desktop the same files are

displayed as webpage hence slightly not so user friendly to use

But Google desktop is superior from the point of view of extensive search bcos

- It can search even those excel files which are as an attachment in Outlook express. Hence

Google desktop search is more extensive as compared to Microsoft search button. Just the file

display is not so good. Hence if u r not able to find any file by Microsoft search button u may

take Google desktop as 2nd option & your lost files will be searched by Google desktop search

button.

Secondly Finding mails option is very superior in Outlook express but in Microsoft outlook the

finding option button does not help in finding out all files. Under such conditions Google

desktop installed slightly helps out bcos a Google desktop search button gets installed on its

own in Microsoft outlook & it helps in finding out mails. However this search gives only one

option for word as in Google web search button. Various buttons like Which subject, which date

etc. as given in Outlook express is not provided in the google search button which gets installed

in OE by its own.

When microsoft buttons are not able to find a particular file on our PC use Google desktop search

button & if the file is there in PC the google desktop button gets it for you. You just have to

scroll a number of pages to find out that file bcos Google finds out all files related with that

word which is not only in file name but also in file contents.

Did you know?

Excel lessons

Did you know?

No. of columns in xlsx / microsoft 2007 is 16384
No. of columns in xls / microsoft 2003 is 256 only


No. of rows in xlsx / microsoft 2007 is 1048576
No. of rows in xls / microsoft 2002 is 65536 only


F4 means pressing this key repeats last command
So if u delete 3 columns then no need to select 3 columns everytime & delete. Instead just press

F4 it will select 3 column on its own & delete 3 columns automatically.

20100604

Do you know?

Do you Know?

A PC cannot calculate factorial beyond 170
Formula for factorial is fact (c4) where C4 can contain any number between 1 to 170
On 171st no. the factorial formula does not work bcos PC cannot make calculations beyond this
- Discovered by Ravi

: means Colon
; means Semi-colon

" means Inverted comma. Also known as quotation mark.
' also means inverted comma. Also known as apostrophe or quotation mark.

RDC means Regional Distribution Center