All posts by Excelshooling

About Excelshooling

We helping individuals and corporate to become exports in Microsoft Excel View all posts by Excelshooling →

04Oct/15

How to remove hyperlink in excel in one shot?

October 4, 2015Excel TipsAdvanced Excel Training in chennai, Excel Training in chennai, Remove hyperlink in Excel, remove hyperlink in macro, remove hyperlink in one shot, remove link in ExcelExcelshooling

If we have Hyperlink in single cell, we can do right click on cell and click “Remove Hyperlink” to remove How can we handle, if we have Hyperlink in sheet more thanRead More…

26Sep/15

How to use excel formula to get dynamic results

September 26, 2015Excel Tipsadvanced-excel-training-chennai, get dynamic results, how to count the text in excel, how to find the lenght of the text in excel, how to trim the text, How to use excel formula, how to use excel formula to get dynamic results, how to use excel fuction, in excel, left function, len function, simple formula can get dynamic resultsExcelshooling

Here, we will see how we can get dynamic output with a simple function. For example, assume that you have an Excel sheet having some 2000 web domain names ending withRead More…

Archives

About Excelshooling