aayaanmayank
Board Regular
- Joined
- Jul 20, 2018
- Messages
- 157
Hi All, can any one help me on this i have two columns if column A starting 4 texts match with column B starting 4 texts then clear the contain from cell which is in column A
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 210"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]MIAMIFLORIDAUSA088317434[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 210"]
<tbody>[TR]
[TD]MIAMI[/TD]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 210"]
<tbody>[TR]
[/TR]
[TR]
[TD]PORTLOREGONUSA972082168[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]PORTLAND[/TD]
[/TR]
[TR]
[TD][TABLE="width: 210"]
<tbody>[TR]
[TD]SUITE1500DISTRICT1018
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]CLEVELAND[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 210"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]MIAMIFLORIDAUSA088317434[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 210"]
<tbody>[TR]
[TD]MIAMI[/TD]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 210"]
<tbody>[TR]
[/TR]
[TR]
[TD]PORTLOREGONUSA972082168[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]PORTLAND[/TD]
[/TR]
[TR]
[TD][TABLE="width: 210"]
<tbody>[TR]
[TD]SUITE1500DISTRICT1018
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]CLEVELAND[/TD]
[/TR]
</tbody>[/TABLE]