Excel Functions & Formulas
How to Remove Vlookup Formula and Keep Values in Excel
Learn how to remove VLOOKUP formulas in Excel and keep values using paste special, shortcuts, and drag and drop methods.
Read article
Author & Spreadsheet Consultant
Shihab Shahriar
88 Articles PublishedPublishing since
Md. Shihab Uddin holds a Graduation in Crop Science and Technology and is pursuing a Postgraduate degree in Soil Science from the University of Rajshahi. With 4+ years of Excel and Google Sheets experience, he specializes in formulas, data cleaning, lookups, automation, VBA, formatting, and file management. He has authored 100+ in-depth Excel articles and is skilled in Power Automate, RPA, and Python. He enjoys creating efficient workflows and solving real-world data problems.
Editorial Review
Articles Published by Shihab Shahriar
Articles by Shihab Shahriar are developed under the guidance of ExcelInsider’s core training program and are technically reviewed by Nehad Ulfat, lead spreadsheet consultant, to ensure accuracy and user-centric value.
Excel Functions & Formulas
How to Apply Dynamic VLOOKUP Formula in Excel
Learn how to use a dynamic VLOOKUP in Excel with MATCH, dynamic column references, and COLUMNS function for flexible lookups.
Read article
Excel Pro Tips
How to Combine Date and Text in Excel (4 Suitable Methods)
Learn how to combine date and text in Excel using CONCAT, ampersand, TODAY, and TEXTJOIN functions with clear examples.
Read article
Excel Pro Tips
How to Bold Text in a Concatenate Formula in Excel
Learn how to bold text in a concatenate formula in Excel using VBA to format specific words or the entire result easily.
Read article
Excel Pro Tips
How to Concatenate String and Integer in Excel Using VBA
Learn how to concatenate string and integer in Excel using VBA with ampersand and addition operators easily.
Read article
Excel Pro Tips
How to Convert Hex to Binary Values in Excel (2 Useful Methods)
Learn how to convert hex to binary values in Excel using the HEX2BIN function and VBA for handling longer hex strings.
Read article
Excel Charts
How to Make an Area Chart in Excel (3 Different Examples)
Learn how to make an area chart in Excel, including simple 2D, stacked 2D, and 3D area charts with clear step by step guidance
Read article
Excel Pro Tips
How to Remove Text from Excel Cell and Leave Numbers
Learn how to remove text from Excel cells and keep only numbers using formulas, Flash Fill, Find & Replace, and VBA macros.
Read article
Excel Pro Tips
How to Automate Data Cleaning in Excel (6 Different Examples)
Learn how to automate data cleaning in Excel using Power Query, Flash Fill, Find & Replace, and formulas to fix messy data fast.
Read article
Excel Pro Tips
How to Extract Data from Multiple PDF Files to Excel
Learn how to extract data from multiple PDF files to Excel using Power Query, Word, and copy paste methods step by step.
Read article
Excel Pro Tips
How to Read a Text File Line by Line in Excel VBA (4 Methods)
Learn how to use VBA to read a text file line by line, display content, and import data into Excel with clear examples.
Read article
Excel Pro Tips
How to Import a Text File to Excel Using VBA (3 Effective Ways)
Learn how to import a text file into Excel using VBA from a specific location with a file picker, and using multiple delimiters step by step.
Read article