Category: Excel Tips

How to unmerge specific cells in Excel using VBA

How to unmerge specific cells in Excel using VBA

How to unmerge specific cells in Excel using VBA Sometimes you just want to unmerge cells which contain some specific value but you want to do it ...
How to create multiple files using sheets in Excel VBA

How to create multiple files using sheets in Excel VBA

How to create multiple files using sheets in Excel VBA How many times you come across a situation where you want to create multiple files usi ...
How to extract text from a bracket cell in excel

How to extract text from a bracket cell in excel

How to extract text from a bracket cell in excel Assuming you have some data in column A in an excel sheet and every cell contains lengthy&nb ...
How to convert multiple text values to a date format using a single formula

How to convert multiple text values to a date format using a single formula

How to convert multiple text values to a date format using a single formula Assuming there is an uncleaned Date format in Column A, some of t ...
How to clean up scraped data in Excel without VBA

How to clean up scraped data in Excel without VBA

How to clean up scraped data in Excel without VBA Before you use your data for reports, analytics or presentation, first you need to clean it as y ...
How to Convert All Cell Values (Text) to UPPER Case VBA

How to Convert All Cell Values (Text) to UPPER Case VBA

How to Convert All Cell Values (Text) to UPPER Case VBA When you want to convert a cell or text value in excel, you apply "Upper" formula in excel ...
How To Transpose / Convert Multiple Rows Into Single Row without VBA and Array Formula

How To Transpose / Convert Multiple Rows Into Single Row without VBA and Array Formula

How To Transpose / Convert Multiple Rows Into Single Row without VBA and Array Formula If you are looking for a solution to Transpose / Convert Multi ...
How to replace other cell values in excel using VBA

How to replace other cell values in excel using VBA

How to replace other cell values in excel using VBA VBA Code Sub Replace() Dim Setrng As Range Dim i As String 'Talentnett Solutions - visit us a ...
Advance Excel Keyboard Shortcuts 2019

Advance Excel Keyboard Shortcuts 2019

Advance Excel Keyboard Shortcuts 2019 Excel shortcuts are basic need if you need to work faster in excel. There are hundreds of shortcut keys you ...
How to apply VLOOKUP without entering a column number

How to apply VLOOKUP without entering a column number

How to apply VLOOKUP without entering a column number Are you still using VLOOKUP in the same old fashion and wonder how to apply VLOOKUP ...