Articles by CA Rishabh Pugalia (ExcelNext)
View Full Profile
Learn how to compare two columns in Excel
Learn how to compare two columns in Excel
Adding suffix in cells in MS Excel
Tricks to Format cells in Excel: Format Cells in Excel (Suffix)
Trick to add digits in a cell in Excel
Tricks to Format cells in Excel: Format Cells in Excel (Prefix)
Tricks to Format cells in Excel: Currency Format (Prefix)
Tricks to Format cells in Excel: Currency Format (Prefix)
Tricks to Format cells in Excel: Trailing Dots
Tricks to Format cells in Excel: Trailing Dots
Tricks to Format cells in Excel: Date Format
Tricks to Format cells in Excel: Date Format
Converting invalid date formats to valid ones in excel
Unclean or Invalid Dates (DMY Format) should be converted to valid data formats.
Converting numbers with minus sign into negative numbers in Excel
Lets see how to achieve this using a hidden trick of Text to Column. Converting numbers with trailing minus sign into negative numbers.
Changing the data format of a column in excel
Transfer Single Columnar Data into Multiple Columns, and customizing the output cell format. (Example: Nos. with zero prefixes such as 000123 must be stored as ...
Splitting text of one cell in multiple columns
Split a name into two columns as last name and first name (Example: AbduSalaam, Ismael)
Popular Articles
- Post Office Schemes Investment Strategy 2026: Know How To Generate Rs 52,000 Monthly?
- TDS on Rent After the Rs 50,000-a-Month Rule: 7 Worked Cases for 2026
- GSTR-9 Due Date For FY 2025-26: Latest Update
- GSTR-9 Applicability for FY 2025-26: Who Must File and Who Is Exempt?
- GST E-invoice 5 Crore Rule: Major Changes from January 2027
- MCA Corporate Law Reforms 2025: Major Changes in Small Company Limits, Director KYC and Fast-Track Mergers
- GST Changes from 1st Nov 2026: New Rules for Post-Supply Discounts
- 1 Lakh Interest Per Month: Check Out the Investment Needed? - Post Office MIS vs SBI
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
CAclubindia
