How to insert split data to particular columns

Hi



I have a data in column C of worksheet 1. The data is a score like 79:74. I use the following Sub to split it into 2 columns (C:D) and it was done.



Here is the code:

Please Login or Register  to view this content.

However, (1) how can I put the 2 columns data to column (E:E) and (G:G)?



(2) Why the number shown in the cell has a small green triangle on the top left corner insides a cell?



Thanks for advice.

Why you didn't continue the question in MrExcel ?

I don't understand why those guys do things like this...

Jindon

Thanks

Cross Post

rylo