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