banner_ad

Articles by CA Rishabh Pugalia (ExcelNext)

avatarView Full Profile

Learn how to compare two columns in Excel

Learn how to compare two columns in Excel

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

Learn how to compare two columns in Excel


Adding suffix in cells in MS Excel

Adding suffix in cells in MS Excel

Posted by CA Rishabh Pugalia (ExcelNext) 23 February 2017 79312 Views

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


Trick to add digits in a cell in Excel

Trick to add digits in a cell in Excel

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

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)

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

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

Posted by CA Rishabh Pugalia (ExcelNext) 10 February 2017 26116 Views

Tricks to Format cells in Excel: Trailing Dots


Tricks to Format cells in Excel: Date Format

Tricks to Format cells in Excel: Date Format

Posted by CA Rishabh Pugalia (ExcelNext) 08 February 2017 35795 Views

Tricks to Format cells in Excel: Date Format


Converting invalid date formats to valid ones in excel

Converting invalid date formats to valid ones in excel

Posted by CA Rishabh Pugalia (ExcelNext) 10 January 2017 23433 Views

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


Converting numbers with minus sign into negative numbers in Excel

Converting numbers with minus sign into negative numbers in Excel

Posted by CA Rishabh Pugalia (ExcelNext) 09 January 2017 15941 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

Changing the data format of a column in excel

Posted by CA Rishabh Pugalia (ExcelNext) 07 January 2017 14923 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

Splitting text of one cell in multiple columns

Posted by CA Rishabh Pugalia (ExcelNext) 06 January 2017 19846 Views

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



Popular Articles




banner

Trending Online Classes

view all classess

CCI Pro
Meet our CAclubindia PRO Members
Subscribe Now

Follow us
add to google news

CCI Articles

You can also submit your article by sending to article@caclubindia.com

submit article

Browse by Category




Latest Job Openings

View all
Company
Featured 02 May 2026
Senior Executive

hitesh chandwani & co

Pune

B.Com

View Details
Company
Featured 29 April 2026
Manager- Finance and Compliance

Naveen Fintech Pvt Ltd

Kolkata

CA Inter

View Details
Company
Featured 14 April 2026
GST CONSULTANT

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 13 April 2026
GST CONSULTANCY

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 28 March 2026
Accountant

Ashok Amol & Associates

New Delhi

B.Com

View Details
Company
Featured 28 March 2026
CA Final

Ashok Amol & Associates

New Delhi

CA Final

View Details
Company
Featured ARTICLESHIP 19 March 2026
Article Assistant

Gupta Sachdeva & Co. Chartered Accountants

New Delhi

CA Final

View Details
Company
Featured 14 March 2026
Associate CA

N N V Satish&co

Hyderabad

CA

View Details