I really didn't know where to post something like this so sorry guys if this not the right section
I have a text file looks like this
I want to import it into Excel file so each info will be in seperated coloumn , even the spaces I need it to stay as it
but when import it I use the spaces as dilimiters so every empty column will be deleted and my fileds will be shifted
how can I keep my tables formatted correctly ? .
Are you trying to import the data from within Excel or are you doing it from another environment such as C, C++, vb.net, vbScript, etc.? Once we get more information we can move this thread to the appropriate forum and proceed from there.
Am using Excel to open the text file,No VB or any external programs
@Stuugie No the Fixed width didn't suffice because all information became in one cell so i can't make data filter or any excel operation
Sorry guys , am not familiar with Excel so when you told me about Fixed width I didn't understand what you meant :( , but now I realize I can click on spaces to create "Fixed width" columns ,
sorry for this misunderstand
thanks for the help guys.