Microsoft excel

This query is : Resolved

Querist : Anonymous

Querist : Anonymous (Querist)

03 July 2012 Greetings of the day to all experts!!!

In excel if we want to find the difference in two numeric value we simply put formula =cell"A1"-cell"B1"

But if there are two alpha numeric values then how can we find the difference with the help of formula...

ex: in cell A1 = Sunil99
in cell B1 = Suneel99

CA Siddhartha Bhardwaj

CA Siddhartha Bhardwaj (Expert)
Follow

03 July 2012 For what purpose do you want to find the difference between two alphanumeric values?

If you want to find whether the two values are equal or not, use A1 = B1.

It will display 'True' or 'False'.

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

Similar Resolved Queries

Unanswered Queries

Popular
Recent

Trending Online Classes

Direct Tax Laws & International Taxation May 26,Sept 26 & Jan 27

CA Arvind Tuli

Enroll Now
Audit Fast Track Recorded Batch For May 26,Sept 26 & Jan 27

CA Aarti Lahoti

Enroll Now
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English

CA Bhanwar Borana & CA Shubham Keswani

Enroll Now

view all classess

Meet our CAclubindia PRO Members

Adesh Mahajan

Sharad Jain

CMA Sajin Odupara

vinal

sunjeev batra

Subscribe Now

Microsoft excel

Similar Resolved Queries

Trending Online Classes

Meet our CAclubindia PRO Members

Quick Links

Browse by Category

Latest Job Openings

CA Final

Accountant

Senior Executive

GST CONSULTANCY

GST CONSULTANT

Manager- Finance and Compliance