How to get excel to ignore letters in a cell

[MustaphaOj]

Hello All,

I have a data set where I need to match some numbers with each other but they have two letters in front of them that make it currently impossible to do.

So for example I have: CP2003 in Cell B2 and RD2003.001 in Cell C2. I would like to know how to get a formula that matches just the 2003 parts together in a “yes” or “no” Format and if for example I have CP2004 In cell B3 and CP2006.001 in cell C3 id also like it to be highlighted that they don’t match. Thank you to everyone willing to help.

 

[gaz_chops]

Welcome to the forum, try something along the lines of -

=if(mid(B3,3,4)=mid(C3,3,4),"Yes","No")

 

[MustaphaOj]

Welcome to the forum, try something along the lines of -

=if(mid(B3,3,4)=mid(C3,3,4),"Yes","No")

Thank you so much. It works perfectly, God bless you!

 

[gaz_chops]

You're welcome, thanks for the feedback.