Most Helpful Member - Excel Google Group
Learn Complex Excel Formulas and their Application
Cell formula to display content, position and formatting of cell
Sometimes we have many questions in mind like :How to know the cell protection status - Locked or Unlocked ?How to know the width of the cell ?How to know alignment ...
Posted Jun 11, 2011, 10:51 AM by Ayush Jain
Extract email address from sentence in cell
Recently I wanted to extract email address from the sentence given in the cell. I got the below formula perfectly working to get this done.EXAMPLE :1) Hello, abc@abc ...
Posted Jun 11, 2011, 10:52 AM by Ayush Jain
Display Feet and Inches as 5' 8 1/2"
When converting metric distances to English units of feet or inches,
you'll end up with a decimal value. But, you may want to display the
value as feet and ...
Posted Mar 26, 2011, 7:06 AM by Ayush Jain
Hidden text in Formula
By using N() function you can enter hidden text in the formula. It is
helpful when you want to display any information along with formula in
single Cell.Example : =2018 ...
Posted Jan 30, 2011, 12:59 AM by Ayush Jain
Extract % from the Securities or any Text
In finance & banking transactions, The interest rate is used in the name of many securities & transactions...If you have this data in excel sheet , then you can filter out the ...
Posted Jan 29, 2011, 11:00 PM by Ayush Jain
Showing posts 1 - 5 of 7. View more »
Excel Blog of the Month
Excel Tips and Tricks
Create an Instant Chart
You can create a chart quickly in Microsoft Excel without having to use the chart button on the toolbar by using these two shortcuts whilst inside a range of data ...
Posted Apr 2, 2011, 8:43 AM by Ayush Jain
Find the currently active cell
If you’ve been scrolling around your spreadsheet and you lose your
place, you can jump back to the currently active cell by pressing the
[Ctrl] + [Backspace] keys.
Posted Mar 24, 2011, 8:11 AM by Ayush Jain
How to hide formulas in MS Excel worksheets
This trick will let you hide the formulas & keeping the worksheet usable, by performing the following steps:Select all cells (either press Ctrl+A or click on the small upper ...
Posted Feb 25, 2011, 11:24 PM by Ayush Jain
Hide the Ribbon in Office 2007 / 2010
Press Control + F1 and ribbon disappears and press again to reappear
ribbon. You can also have it disappear so it will come back with a
single click on any tab ...
Posted Jan 30, 2011, 7:28 AM by Ayush Jain
Inconsistent date entries
You need to exercise caution when entering dates by using two digits for
the year. When you do so, Excel has some rules that kick in to
determine which century ...
Posted Jan 30, 2011, 7:26 AM by Ayush Jain
Showing posts 1 - 5 of 8. View more »
VBA Macros Code Snippets
VBA code to import the MS Access query data into MS Excel
Sub importAccessdata(strDBPath As String, strTableName As String) Dim cnn As ADODB.Connection Dim rs As ADODB.Recordset Dim sQRY As String Dim strFilePath As String strFilePath = strDBPath Set cnn ...
Posted Jun 2, 2016, 9:55 AM by Ayush Jain
Store excel range in an array variable
If you want to store excel range in string array variable , you can use this user define function.
Public Function ReturnArraySel(xlRange As Range) As String()
Dim strArray() As String ...
Posted Nov 10, 2011, 12:58 AM by Ayush Jain
Get Full Network Path of mapped drive
To get the full network path of mapped drive in windows, you can use the below VBA function. The function returns the full path on input of drive name like ...
Posted Jun 26, 2011, 1:39 AM by Ayush Jain
Calculate how long macro runs
If you want to know the duration of macro execution , You can use the below macro :Sub TimeTaken() Dim strTime1 As String, strTime2 As String strTime1 = Format(Now(), "mm-dd ...
Posted Jun 19, 2011, 9:12 AM by Ayush Jain
Column Number to Alphabetical reference
The below function can be used to convert any Column Number into Alphabets.
example :- If you pass 1 to the function, it will Return A. If you pass
26, It ...
Posted Mar 26, 2011, 7:37 AM by Ayush Jain
Showing posts 1 - 5 of 10. View more »