I have a CSV file that is pipe delimited. I saved the file as txt and am converting it into Excel 2003. I have 2 problems with the file. It is pipe delimited, but one column has a pipe in it and I need that column to NOT split. The other problem is that in any fields that have commas in them, it is replacing the comma with a weird symbol. Any help would be appreciated.
Hello dgrimes1,
It would help to see the text file and have more details about how you are importing the file: by wizard, macro, etc.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
dgrimes1 
Register To Reply
Bookmarks