Excel Pro Tips
How to Split a Cell into Two Rows in Excel (6 Useful Methods)
Learn how to split a cell into two rows in Excel using manual methods, formulas, Power Query, VBA, and advanced functions like TEXTSPLIT.
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
Separate First and Last Names with Space in Excel Formula
Learn how to separate first and last names with space in Excel using formulas like LEFT, RIGHT, FIND, TEXTSPLIT, TEXTBEFORE, and TEXTAFTER.
Read article
Excel Pro Tips
How to Convert Text to Columns with Line Break in Excel
Learn how to convert text to columns in Excel using line breaks with Text to Columns, TEXTSPLIT, and Power Query for easy data splitting.
Read article
Excel Pro Tips
How to Extract Specific Numbers from a Cell in Excel
Learn how to extract specific numbers from a cell in Excel using functions like MID, TEXTJOIN, REGEX, Power Query, VBA, and more.
Read article
Excel Pro Tips
How to Separate Date in Excel Using Formula (3 Suitable Methods)
Easily separate date in Excel using formulas like DAY, MONTH, YEAR, TEXT, INT, TRUNC, ROUNDDOWN, and LEFT to extract specific date parts.
Read article
Excel Pro Tips
How to Translate Multiple Cells in Excel (4 Effective Ways)
Learn how to translate multiple cells in Excel using built-in tools, Word, Microsoft 365 functions, and Power Query with Google API.
Read article
Excel Pro Tips
How to Make a Venn Diagram in Excel (2 Easy Methods)
Learn how to make a Venn diagram in Excel using the SmartArt feature or by customizing shapes manually for more flexible designs.
Read article
Excel Pro Tips
How to Create a Timeline in Excel with Dates (6 Different Ways)
Learn how to create a timeline in Excel using templates, SmartArt, PivotTables, scatter plots, Gantt charts, and manual design tools.
Read article
Excel Pro Tips
How to Convert Text File to Excel Automatically (5 Simple Ways)
Learn how to automatically convert a text file to Excel using file extension tricks, Power Query, VBA, and Excel’s built-in import tools.
Read article
Excel Pro Tips
How to Paste Comma Separated Values into Excel (4 Easy Ways)
Learn how to paste comma-separated values into Excel using Text to Columns, From Text/CSV, Power Query, and the TEXTSPLIT function.
Read article
Excel Pro Tips
How to Convert XML to Excel Table (3 Suitable Methods)
Learn how to convert XML to Excel table using built-in import tools, Power Query, and VBA for handling simple to complex XML data.
Read article
Excel Pro Tips
How to Send Bulk Email from Outlook Using Excel
Learn how to send bulk emails from Outlook using Excel with a VBA macro or Mail Merge, plus tips to avoid spam and manage sending limits.
Read article