In suppot of this thread
https://excelfox.com/forum/showthrea...5292#post15292

Input data


_____ Workbook: VBA3.xls ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E
F
1
 Find word 1Abc 2wer# 3smar 4chris
2
 AP1k AP1k, 6-9| AP1k, 10-13
3
 ForCome ForCome, 13-19
4
5
 Double Double, 14-16 | Double, 14-16| Double, 14-16 Double, 14-16| Double, 14-16 Double, 14-16| Double, 14-16
Worksheet: inputA


Wanted Output

_____ Workbook: VBA3.xls ( Using Excel 2007 32 bit )
Row\Col
A
B
1
 Output
2
 1Abc
3
 2wer# AP1k, 6-9
4
 2wer# AP1k, 10-13
5
 2wer# Double, 14-16
6
 2wer# Double, 14-16
7
 2wer# Double, 14-16
8
 3smar ForCome, 13-19
9
 3smar Double, 14-16
10
 3smar Double, 14-16
11
 4chris Double, 14-16
12
 4chris Double, 14-16
Worksheet: OutputB


Results after running macro in next post

_____ Workbook: VBA3.xls ( Using Excel 2007 32 bit )
Row\Col
A
B
1
2
 1Abc
3
 2wer# AP1k, 6-9
4
 2wer# AP1k, 10-13
5
 2wer# Double, 14-16
6
 2wer# Double, 14-16
7
 2wer# Double, 14-16
8
 3smar ForCome, 13-19
9
 3smar Double, 14-16
10
 3smar Double, 14-16
11
 4chris Double, 14-16
12
 4chris Double, 14-16
Worksheet: Output