Compare data and extract Software name, year and version

[Shankar Nar]

Hi Experts,

I was not able to find a thread similar, so starting this thread.
I am a novice in excel and I am trying to compare the softwares of an application with the master data list.
My questions are as below.

1. I have to compare 2 strings in this scenerio (e.g COL A - microsoft visual c++ redistributable 2015 x64
Col - B - visual c++ redistributable 2015 x64)
2. I have to extract the Software name, year and version from Col 1.

Below is the data.

[TABLE="class: outer_border, width: 755"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Software List - MasterData
[/TD]
[TD]Software List - Application Data
[/TD]
[TD]Version
[/TD]
[TD]Year
[/TD]
[/TR]
[TR]
[TD]microsoft visual c++ 2013[/TD]
[TD]visual c++ redistributable 2015 x64[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]microsoft visual c++ 2013 x86[/TD]
[TD]visual c++ 2013[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]microsoft visual c++ 2015 x86
[/TD]
[TD]r for windows 3.1.1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ibm sterling connect:direct 4.2[/TD]
[TD]activeperl-5.24.1.2402-mswin32-x86-64int-401627[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ibm urbancode deploy agent 6.2[/TD]
[TD]hp sa agent
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]microsoft visual c++ redistributable 2015 x64[/TD]
[TD]r for windows 3.3.2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]microsoft visual c++ redistributable 2015 x86[/TD]
[TD]syslog-ng agent for windows (remove only)[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]