Hi,

This is my part of code

Please Login or Register  to view this content.
So basically I import from another sheet a couple of rows
COND:1:01:04KS-200 WELL ONLINE HEADER 5 CHECK::Y,.,.,.,.,Y,.,.,.,.,.,.,Y,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.;
Above is one column and one line.

After the TextToColumns I want it to have it in this format.
Capture.PNG

But because the first dot or Y is before the comma it won't be as supposed to be.

How can I fix this as easily?

Thanks in advance,

Bas