Appendix Thread 2. ( Codes for other Threads, HTML Tables, etc.)

[DocAElstein]

Test data in support of this Post:
http://www.excelfox.com/forum/showth...0766#post10766



Using Excel 2007 32 bit

Row\Col	A	B	C	D	E	F
1	1 L 1	1 L 1,1 L 1
2	1 G 1	1 E 1	1 L 1,1 L 1	1 E 1
3	1 G 1	1 E 1	1 L 1,1 L 1	1 E 1	1 G 1
4	1 E 1	1 G 1
5

Worksheet: Sheet2


Using Excel 2007 32 bit

Row\Col	A	B	C	D	E	F	G	H	I	J
1	1 L 1	1 E 1	1 L 1,1 L 1	1 G 1
2	1 G 1	1 E 1	1 L 1	1 L 1	1 G 1
3	1 L 1	1 L 1,1 L 1	1 L 1	1 G 1
4	1 L 1	1 L 1,1 L 1
5	1 L 1	1 G 1	1 E 1	1 L 1
6	1 G 1	1 L 1	1 L 1,1 L 1	1 L 1	1 L 1	1 G 1
7	1 E 1	1 E 1	1 L 1,1 L 1	1 L 1	1 G 1
8	1 E 1	1 G 1	1 E 1	1 L 1,1 L 1	1 G 1	1 G 1	1 G 1	1 G 1
9	1 E 1	1 E 1	1 L 1	1 L 1	1 G 1	1 G 1	1 G 1	1 G 1	1 G 1
10

Worksheet: Sheet3


_._______________________

The results after running the code given on Post #3 of main Thread ( http://www.excelfox.com/forum/showth...0766#post10766 )
Using Excel 2007 32 bit

Row\Col	A	B	C	D
1	20abc
2	abc20
3	def
4	ghi
5

Worksheet: Sheet4