Excel Pro Tips
How to Find the First Number in a String in Excel
Learn how to find the first number in a string in Excel using MID, FIND, MATCH, CODE, XLOOKUP, INDEX-MATCH, or VBA for automation.
Read article
Author & Spreadsheet Consultant
Tasmia Rahim
268 Articles PublishedPublishing since
Tasmia Rahim holds a B.Sc in Electrical Engineering with a focus on automation and embedded systems, supporting logic-driven spreadsheet workflows. With 2 years of Excel and Google Sheets experience, she works with conditional formatting and basic automation. She is interested in using macros and ActiveX controls to simplify Excel tasks and improve usability.
Editorial Review
Articles Published by Tasmia Rahim
Articles by Tasmia Rahim 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 Change Checkbox Color in Excel (4 Suitable Ways)
Change checkbox color in Excel with direct formatting, conditional formatting for checked or unchecked boxes, or simple VBA.
Read article
Excel Pro Tips
How to Remove Read Only from Excel (8 Simple Ways)
Remove Excel read-only mode by editing file properties, unprotecting the workbook, adjusting settings, and fixing permissions.
Read article
Excel Pro Tips
How to Find the First Value Greater Than a Number in Excel
Learn how to find the first value greater than a number in Excel using INDEX-MATCH, MATCH, MIN, or a VBA approach.
Read article
Excel Pro Tips
How to Extract Text after the Nth Character in Excel
Learn how to extract text after the Nth character in Excel using RIGHT, FIND, MID, TEXTAFTER, TEXTSPLIT, INDEX, TRIM, and SUBSTITUTE.
Read article
Excel Pro Tips
Extract Text After the Last Instance of a Character in Excel
Learn how to extract text after the last character in Excel using RIGHT, SEARCH, SUBSTITUTE, TEXTAFTER, REPLACE, XLOOKUP, and custom VBA.
Read article
Excel Pro Tips
How to Extract Certain Text from a Cell in Excel
Learn how to extract specific text in Excel using LEFT, RIGHT, MID, TEXTBEFORE/AFTER, FIND, SEARCH, SUBSTITUTE, and delimiter-based formulas.
Read article
Excel Pro Tips
How to Convert Hours to Decimal in Excel (3 Quick Ways)
Learn how to convert hours to decimal in Excel using simple multiplication, HOUR/MINUTE/SECOND functions, and the CONVERT function.
Read article
Excel Pro Tips
How to Convert Seconds to Hours, Minutes, and Seconds in Excel
Learn how to convert seconds to hours, minutes, and seconds in Excel using INT, ROUND, CONVERT, TEXT, and dynamic formatting techniques.
Read article
Excel Pro Tips
How to Convert Epoch Time to a Date in Excel
Learn how to convert epoch time to Excel dates using formulas, handle milliseconds, adjust time zones, format results, and create a VBA UDF.
Read article
Excel Pro Tips
How to Subtract Date and Time in Excel (6 Examples)
Learn to subtract date and time in Excel using INT, TEXT, HOUR, MINUTE, TIME, and NOW to calculate precise payroll durations accurately.
Read article
Excel Pro Tips
How to Calculate Hours and Minutes for Payroll in Excel
Learn how to calculate payroll hours and minutes in Excel using subtraction, TEXT, IF, HOUR, MINUTE, TIME, MOD, and NOW functions.
Read article