mitsoulas13
New Member
- Joined
- May 26, 2016
- Messages
- 2
Hi guys,
I have a column filled with cells as the example below:
COMPANY NAME (in Upper case,not fixed number of words) Category Name (in proper case, not fixed number of words)
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 401"]
<tbody>[TR]
[TD="width: 401, align: left"]BRAVO AQUA PARK Playgrounds
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BRAVO TRAVEL Travel Agencies - Ticket Agencies [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ECONOMIC GROWTH AE Business Consultant
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 401"]
<tbody>[TR]
[TD="width: 401, align: left"][/TD]
[/TR]
</tbody>[/TABLE]
and so one (total number of cells 476K). The only way to distinguish[FONT=arial, sans-serif] the company name and the category name is that the company name is always in upper case and the category name starts in proper case)
[/FONT]
I want to text to column those cell, splitting them by the case, meaning:
[TABLE="width: 500"]
<tbody>[TR]
[TD]BRAVO AQUA PARK[/TD]
[TD]Playgrounds [/TD]
[/TR]
[TR]
[TD]BRAVO TRAVEL[/TD]
[TD]Travel Agencies - Ticket Agencies [/TD]
[/TR]
[TR]
[TD]ECONOMIC GROWTH AE[/TD]
[TD]Business Consultant[/TD]
[/TR]
</tbody>[/TABLE]
Does anyone have any clue how I'm supposed to do that (if that's possible)? Thanks in advance
I have a column filled with cells as the example below:
COMPANY NAME (in Upper case,not fixed number of words) Category Name (in proper case, not fixed number of words)
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 401"]
<tbody>[TR]
[TD="width: 401, align: left"]BRAVO AQUA PARK Playgrounds
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BRAVO TRAVEL Travel Agencies - Ticket Agencies [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ECONOMIC GROWTH AE Business Consultant
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 401"]
<tbody>[TR]
[TD="width: 401, align: left"][/TD]
[/TR]
</tbody>[/TABLE]
and so one (total number of cells 476K). The only way to distinguish[FONT=arial, sans-serif] the company name and the category name is that the company name is always in upper case and the category name starts in proper case)
[/FONT]
I want to text to column those cell, splitting them by the case, meaning:
[TABLE="width: 500"]
<tbody>[TR]
[TD]BRAVO AQUA PARK[/TD]
[TD]Playgrounds [/TD]
[/TR]
[TR]
[TD]BRAVO TRAVEL[/TD]
[TD]Travel Agencies - Ticket Agencies [/TD]
[/TR]
[TR]
[TD]ECONOMIC GROWTH AE[/TD]
[TD]Business Consultant[/TD]
[/TR]
</tbody>[/TABLE]
Does anyone have any clue how I'm supposed to do that (if that's possible)? Thanks in advance