How to find out two words matching with one additional Number

Closed
Kolachana Posts 1 Registration date Saturday 11 May 2013 Status Member Last seen 11 May 2013 - 11 May 2013 à 05:11
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 13 May 2013 à 11:44
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.
Related:

1 response

TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
13 May 2013 à 11:44
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