Hello Guys,
i'd like to be able to open a textual file on excel.
the file fields are seperated in comma.
however, i need to seperate the file to more than one sheet.
what kind of delimiter do i need to use ???
.i.e. here is an example of what i'd like to do, i hope it emphasis the idea
sheet1:
field1,23,53
field2,43,53
field3,233,53
field4,2,53
field5,23,53
sheet2:
field6,23,53
field7,43,53
field8,233,53
field9,2,53
field10,23,53
thanks,
i'd like to be able to open a textual file on excel.
the file fields are seperated in comma.
however, i need to seperate the file to more than one sheet.
what kind of delimiter do i need to use ???
.i.e. here is an example of what i'd like to do, i hope it emphasis the idea
sheet1:
field1,23,53
field2,43,53
field3,233,53
field4,2,53
field5,23,53
sheet2:
field6,23,53
field7,43,53
field8,233,53
field9,2,53
field10,23,53
thanks,