create new table after get the line of information that i want form txt ! but it has different line space
i'm very sorry that i cant find the right english words to explain for this problem (i'm foreigner)
this is my question how can i import it to another sheet (in same worksheet) as a nice table.
what i need to use VBA or Fucntion
Thank You
Attachment | Size |
---|---|
ABC2.txt | 4.28 KB |
Result that i want.xlsx | 9.37 KB |
RangeToTabDelimitedTextFile_Ans.xls | 42.5 KB |
create new table after get the line of information that i want f
Neither VBA nor function: Data, From Text, Select your text file, Use "Delimited", for separators check "Space" and "Other". In "Other" type ":". Press "Finish".