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...???
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.
Perhaps your actual file has some non-printable character as delimiter, when logic of splitting will be more reliable.
Excel Try Power Query.
If your data is as consistent as your screenshot suggests, it's not so difficult. see attached.
Thank you for giving the solution. Sir can you explain me procedure in Power Query?
Please?
