Excel Pro Tips
How to Extract Text After Character in Excel (4 Suitable Ways)
Learn how to extract text after a character in Excel using MID, FIND, LEN, RIGHT, SEARCH functions, or the Text to Columns feature.
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 Pro Tips
How to Subtract Minutes from Time in Excel (3 Suitable Ways)
Learn how to subtract minutes from time in Excel using the TIME function, fraction of day method, and dynamic adjustments with IF and TIME.
Read article
Excel Pro Tips
Calculate the Number of Weeks Between Two Dates in Excel
Learn how to calculate the number of weeks between two dates in Excel using DAYS, INT, DATEDIF, simple division, and TODAY functions.
Read article
Excel Pro Tips
How To Convert Timestamp To Date In Excel (5 Suitable Ways)
Learn how to convert timestamps to dates in Excel using TEXT functions, formulas for Unix timestamps, base date adjustments, or VBA methods.
Read article
Excel Pro Tips
How to Fill Blank Cells with Value Above in Excel (4 Easy Tricks)
Learn how to fill blank cells with the value above in Excel using Go To Special, VBA, Power Query Fill Down, or a simple formula method.
Read article
Excel Pro Tips
How To Split Excel Sheet into Multiple Sheets Based on Rows
Learn how to split an Excel sheet into multiple sheets based on rows using VBA, manual copy-paste, or Pivot Table options.
Read article
Excel Pro Tips
How to Convert Number to Hours and Minutes in Excel
Learn how to convert numbers to hours and minutes in Excel using formulas, functions, and formatting tips for accurate time calculations.
Read article
Excel Pro Tips
How to Make First Row as Header in Excel (3 Easy Methods)
Learn how to make the first row a header in Excel using Freeze Panes, converting data to a table, or applying headers in Power Query Editor.
Read article
Excel Pro Tips
How to Delete Filtered Rows in Excel (4 Suitable Ways)
Learn how to delete filtered rows in Excel using basic filters, visible cells only, Power Query, or the Advanced Filter method.
Read article
Excel Pro Tips
How to Make Excel Go to Next Line Automatically
Learn how to make Excel go to the next line automatically using Wrap Text, manual breaks with Alt+Enter, and Find & Replace with Ctrl+J.
Read article
Excel Pro Tips
How To Find Text in Range and Return Cell Reference in Excel
Learn how to find specific text in a range and return its cell reference in Excel using CELL, INDEX, MATCH, and ADDRESS functions.
Read article
Excel Pro Tips
How to Convert Number to Date YYYYMMDD in Excel
Learn how to convert numbers to date format YYYYMMDD in Excel using formulas, Text to Columns, and custom number formatting techniques.
Read article