velicumarius
New Member
- Joined
- Sep 21, 2016
- Messages
- 4
Hello,
I have a problem when I am copying a csv text from a .txt file into Column A - on some rows the data is split between col A and C.
I don't want to use the import csv. function because this is part of an RPA process and I want to keep it as simple as possible.
Basically, what I am doing is to open a .txt file that contains csv formatted data, I am copying all the information and paste it into an excel file in column A.
From here I have small vba code that is doing the text_to_columns part which should not be the problem since I tried to do it manually and I have the same problem.
Thank you,
Marius
I have a problem when I am copying a csv text from a .txt file into Column A - on some rows the data is split between col A and C.
I don't want to use the import csv. function because this is part of an RPA process and I want to keep it as simple as possible.
Basically, what I am doing is to open a .txt file that contains csv formatted data, I am copying all the information and paste it into an excel file in column A.
From here I have small vba code that is doing the text_to_columns part which should not be the problem since I tried to do it manually and I have the same problem.
Thank you,
Marius
. There are two tab spaces in the csv text and this is way excel is moving the information all the way to column C.
