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

Question

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

Report

Kolachana

Posts: 1
Registration date: Saturday May 11, 2013
Status: Member
Last seen: May 11, 2013

- May 11, 2013 at 05:11 AM
TrowaD

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

- May 13, 2013 at 11:44 AM

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.

How to find out two words matching with one additional Number
Modern warfare cant find match ✓ - Forum - Video Games
Facebook says my email does not match an account ✓ - Forum - Laptop
Excel partial match two columns - How-To - Excel
My Facebook account doesn't exist anymore ✓ - Forum - Facebook
Index match ignore blank cells ✓ - Forum - Excel

1 reply

Ask a question

TrowaD · Answer 1 · 2013-05-13T11:44:18-0400

Answer 1 / 1

TrowaD

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

460
May 13, 2013 at 11:44 AM

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

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

1 reply

Your reply

Subscribe To Our Newsletter!