troubleshooting Question

Is it possible to make a command such as =LEFT(), case specific in Excel?

Avatar of Steve_Brady
Steve_BradyFlag for United States of America asked on
Microsoft Excel
4 Comments1 Solution207 ViewsLast Modified:
Hello,

In Excel (2007), is it possible to make a command such as =LEFT(), case specific?

For example, suppose you are evaluating the first two characters in A1 & A2 with the following formula in A3:

          =IF(LEFT(A1,2)=LEFT(A2,2),"YES","NO")

If A1 & A2 contain the following:

          A1:   October
          A2:   Octopus
          A3:   =IF(LEFT(A1,2)=LEFT(A2,2),"YES","NO")

then A3 will return:  YES.  Similarly, if the entry in A2 is changed as shown here:

          A1:   October
          A2:   octopus
          A3:   =IF(LEFT(A1,2)=LEFT(A2,2),"YES","NO")

then A3 will still return:  YES

Is there any way to modify the formula in A3 so that it will detect the different case of the letter "O" and as a result, return "NO" in the second example?

Thanks
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros