Ashrafe07
02-05-2015, 09:58 PM
I am having the data mention below, which I need that find a specific character it should copy the content into next cell, Any help using array code is more helpI am having the data mention below, which I need that find a specific character it should copy the content into next cell, Any help using array code is more helpfull. The Special Character here is (*).
Input
Column1 Column2
Adam
1212*14579*44556
John
3251
Stephen
12559*47895
Richard
8879*45487*464647*454647
Monty
8787*1114*1115*1116*117*118
Mark
5456
Output
Column1 Column2
Adam
1212
14579
44556
John
3251
Stephen
12559
47895
Richard
88799
45487
464647
454647
Monty
8879
1114
1115
1116
117
118
Mark
5456
Input
Column1 Column2
Adam
1212*14579*44556
John
3251
Stephen
12559*47895
Richard
8879*45487*464647*454647
Monty
8787*1114*1115*1116*117*118
Mark
5456
Output
Column1 Column2
Adam
1212
14579
44556
John
3251
Stephen
12559
47895
Richard
88799
45487
464647
454647
Monty
8879
1114
1115
1116
117
118
Mark
5456