Forum Discussion
Import option without delimeter
Hello,
How to import text file to excel which does not have any delimiter, can we still import that file with accurate columns?
Please help...???
Waiting for your reply...???
11 Replies
You may use Fixed Width. In any case Excel shall know how to split on columns,
Thank you for the reply sir... Can we insert with the help of VBA code?
The Import Text Wizard has two options: Fixed Width and Delimited. If your text file doesn't have a delimiter and if the columns don't have a fixed width, there is no way to divide the data into columns accurately - you will probably have to correct the data manually.
Thank you for the reply sir... Can we insert with the help of VBA code?
It all depends on what the text file looks like. Without knowing that it's impossible to provide help.
