Articles by CA Rishabh Pugalia (ExcelNext)

avatarView Full Profile

Learn how to compare two columns in Excel

Posted by CA Rishabh Pugalia (ExcelNext) 17 March 2017 19008 Views

Learn how to compare two columns in Excel



Adding suffix in cells in MS Excel

Posted by CA Rishabh Pugalia (ExcelNext) 22 August 2017 79528 Views

Tricks to Format cells in Excel: Format Cells in Excel (Suffix)



Trick to add digits in a cell in Excel

Posted by CA Rishabh Pugalia (ExcelNext) 21 February 2017 12001 Views

Tricks to Format cells in Excel: Format Cells in Excel (Prefix)



Tricks to Format cells in Excel: Currency Format (Prefix)

Posted by CA Rishabh Pugalia (ExcelNext) 15 February 2017 24259 Views

Tricks to Format cells in Excel: Currency Format (Prefix)



Tricks to Format cells in Excel: Trailing Dots

Posted by CA Rishabh Pugalia (ExcelNext) 09 August 2017 26198 Views

Tricks to Format cells in Excel: Trailing Dots



Tricks to Format cells in Excel: Date Format

Posted by CA Rishabh Pugalia (ExcelNext) 07 August 2017 35874 Views

Tricks to Format cells in Excel: Date Format



Converting invalid date formats to valid ones in excel

Posted by CA Rishabh Pugalia (ExcelNext) 26 April 2021 23469 Views

Unclean or Invalid Dates (DMY Format) should be converted to valid data formats.



Converting numbers with minus sign into negative numbers in Excel

Posted by CA Rishabh Pugalia (ExcelNext) 26 April 2021 15978 Views

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

Posted by CA Rishabh Pugalia (ExcelNext) 06 July 2017 14969 Views

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

Posted by CA Rishabh Pugalia (ExcelNext) 07 January 2017 19888 Views

Split a name into two columns as last name and first name (Example: AbduSalaam, Ismael)




Popular Articles





CCI Pro

CCI Articles

submit article



Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details
Company
13 November 2026
Accountant

New Mobile India

Muzaffarpur

B.Com

View Details
Company
10 November 2026
Direct Tax Manager

CAAQ CONSULTANCY PVT LTD

New Delhi

CA Final

View Details
Company
ARTICLESHIP 25 October 2026
Article Intern (CA Articleship)

Arpan Bohra & Co

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 16 November 2026
Audit Executives

Loonker Godawat And Company

Bengaluru

B.Com

View Details
Company
12 November 2026
Tax Product Specialist

BharatX.ai

Gurgaon

B.Com

View Details
Company
Featured 07 November 2026
Paid Assisstant

DPV & Associates

Chennai

CA Inter

View Details