How to find out two words matching with one additional Number [Closed]

Report
Posts
1
Registration date
Saturday May 11, 2013
Status
Member
Last seen
May 11, 2013
-
Posts
2742
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 4, 2021
-
Hi.. Please tell me how to find out matching two words with only one differnce. If Two Columns of Excel contains Data like Vehcile Numbers MH01A123 and MH1A123 here the only Zero added in first number.

Please reply which function in Excel suits to trace the same.

Regards,
Pavan.

1 reply

Posts
2742
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 4, 2021
460
Hi Kolachana,

What do you want to achieve?

Do you want to remove the 0 from the first or add to the second number?

Is it always the third character?
Is it always a 0?
Can there be a 0 in the rest of the number?

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!