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 18965 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 79391 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 11956 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 24183 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 26133 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 35798 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 23435 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 15943 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 14927 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 19850 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
01 June 2026
Audit, Taxation & Compliance Executive

R P S K & Associates

Nashik

CA Inter

View Details
Company
26 May 2026
CA / MBA (Finance) / CMA / M.Com (Finance)

Sri Aurobindo Gnostic Centre of Education

New Delhi

CA

View Details
Company
24 May 2026
Accounts & Tax Executive

PARAS KHURANA AND CO

New Delhi

B.Com

View Details
Company
ARTICLESHIP 28 May 2026
Accounts, Audit & Compliance Executive

Shyam Joshi & Associates

Pune

B.Com

View Details
Company
26 May 2026
Senior Accountant cum purchase Manager

Vardhaman Group of India

Pimpri Chinchwad

CA Inter

View Details
Company
14 May 2026
ICSI Trainees for 21 Months and Semi-Qualified CS

CMNITY HIRE

New Delhi

Others

View Details
Company
ARTICLESHIP 09 June 2026
Article Trainee

Numbertree LLP

Mumbai

CA Inter

View Details
Company
19 May 2026
Fundraising Expert

MentorsWorld Ventures Private Limited

Ahmedabad

Others

View Details