Hola,
I have a comma delimited txt file that I've exported out of a Word form. I'm able to get all the fields to import into Excel nicely enough, but having a problem with one thing...
I need excel to move to the next row down, then move over a few columns and continue writing.
Layout ideally would look something like:
"Name1" "Phone1" "Unix_path1" "User_Per1" "Group_Per1" "World_Per1" "Mgr1"
"Name1" "Phone1" "Unix_path2" "User_Per2" "Group_Per2" "World_Per2" "Mgr1"
"Name1" "Phone1" "Unix_path3" "User_Per3" "Group_Per3" "World_Per3" "Mgr1"
etc...
As you probably guessed, the Word Form has a grid right in the middle of it and the excel sheet would be more usable with this "new row" inserted rather than having everything in one, very long row.
Any ideas? Something like a carriage return once it hits "Unix_Path" and a trick to copy the preceding user name/ending Mgr?
Thanks much
I have a comma delimited txt file that I've exported out of a Word form. I'm able to get all the fields to import into Excel nicely enough, but having a problem with one thing...
I need excel to move to the next row down, then move over a few columns and continue writing.
Layout ideally would look something like:
"Name1" "Phone1" "Unix_path1" "User_Per1" "Group_Per1" "World_Per1" "Mgr1"
"Name1" "Phone1" "Unix_path2" "User_Per2" "Group_Per2" "World_Per2" "Mgr1"
"Name1" "Phone1" "Unix_path3" "User_Per3" "Group_Per3" "World_Per3" "Mgr1"
etc...
As you probably guessed, the Word Form has a grid right in the middle of it and the excel sheet would be more usable with this "new row" inserted rather than having everything in one, very long row.
Any ideas? Something like a carriage return once it hits "Unix_Path" and a trick to copy the preceding user name/ending Mgr?
Thanks much