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
Search This Blog
Search Engine
Custom Search
20100627
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.
-----------------------------------------------
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.
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.
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
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
Subscribe to:
Posts (Atom)