Hi Excel People
I am trying to create a file to upload to the bank in Excel as the accounting system won't do it. :-(
I need to create a text file, with commas that separate the fields. If I save it as a text file there are no commas and if I save it as a csv then the bank upload fails as its a unknown file type. Any ideas?
Thanks
Andy
Welcome to the forum.
This is untested, but save as .csv, then manually change the file suffix from .csv to .txt - see if this works.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Thanks for you response.
When I rename the file in Explorer it stays as a CSV file. I can open it in Notepad and resave it as a text file and it keeps the commas. Its's not ideal as I want to keep it as simple as possible.
Any other thoughts? The perfect way would be able to do it straight from Excel.
Is your problem the comma or the semi-comma?
Could you show a 2 to 3 line of what you want for clarification?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks