Articles by CA Rishabh Pugalia (ExcelNext)
View Full Profile
Learn how to compare two columns in Excel
CA Rishabh Pugalia (ExcelNext) 17 March 2017 at 11:06Learn how to compare two columns in Excel
Adding suffix in cells in MS Excel
CA Rishabh Pugalia (ExcelNext) 23 February 2017 at 10:57Tricks to Format cells in Excel: Format Cells in Excel (Suffix)
Trick to add digits in a cell in Excel
CA Rishabh Pugalia (ExcelNext) 21 February 2017 at 11:17Tricks to Format cells in Excel: Format Cells in Excel (Prefix)
Tricks to Format cells in Excel: Currency Format (Prefix)
CA Rishabh Pugalia (ExcelNext) 15 February 2017 at 11:28Tricks to Format cells in Excel: Currency Format (Prefix)
Tricks to Format cells in Excel: Trailing Dots
CA Rishabh Pugalia (ExcelNext) 10 February 2017 at 10:47Tricks to Format cells in Excel: Trailing Dots
Tricks to Format cells in Excel: Date Format
CA Rishabh Pugalia (ExcelNext) 08 February 2017 at 10:52Tricks to Format cells in Excel: Date Format
Converting invalid date formats to valid ones in excel
CA Rishabh Pugalia (ExcelNext) 10 January 2017 at 10:43Unclean or Invalid Dates (DMY Format) should be converted to valid data formats.
Converting numbers with minus sign into negative numbers in Excel
CA Rishabh Pugalia (ExcelNext) 09 January 2017 at 11:10Lets 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
CA Rishabh Pugalia (ExcelNext) 07 January 2017 at 12:59Transfer 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
CA Rishabh Pugalia (ExcelNext) 06 January 2017 at 11:05Split a name into two columns as last name and first name (Example: AbduSalaam, Ismael)
Popular Articles
- RCM on Rent for Family-Owned Properties: Impact of Notification No. 09/2024
- Resolving Gaps Between GSTR-2B and GSTR-3B Data
- GST Amnesty Scheme 2024: Sec 128A of CGST Act 2017
- Understanding the New IMS (Invoice Management System) on GST Portal
- Updates Related To Revamp of IT Act 1961
- CBDT's Revised Condonation Timeline: A Chartered Accountant's Perspective
- Choosing the Best Tax Regime for an Annual Income of Rs 10 Lakh: New vs Old
- Clarification on Non-Generation of GSTR-2B for October 2024
CAclubindia
