Delete excel columns - Free Excel Tutorial

Extract Multiple Match Values into Separate Columns

January 29, 2022

If you have a few values/items in the excel sheet and you are thinking that with the aid of the “VlOOKUP” function you can look for a specific value, extract it and then put the matching item into the separate column in Ms Excel easily, then congratulations, you are thinking right, but here a problem… read more »

How to extract word that containing a specific character

January 6, 2018

This post will guide you how to extract word that containing a specific character using formula in excel. How to get a word that contains a specific character (such as: @, comma, hash, etc.) in a text string in one cell. Extract word that containing a specific character If you want to extract word that… read more »

Excel Columns

November 5, 2017

Contents: Insert Column | Delete Column | Hide Column | Unhide row | Sizing Column How do I insert a new column in excel? How do I delete a column in excel? How to delete multiple columns in Excel workbook? How to hide a column from being displayed in excel? How to unhide the hidden columns in excel? This… read more »

Excel Rows

November 5, 2017

Contents: insert excel row | delete excel row | hide excel row | unhide row | sizing excel row How do I insert a new row in excel? How do I delete a row in excel? How to delete multiple rows in Excel workbook? How to hide a row from being displayed in excel? How… read more »