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...???
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?
