acct amount No date Vendor name R A
345678912 3840.00 5154 05/03/19 Supermarket R A
It is supposed to look like this
345678912,3840.00,5654,050319,Supermarket,R A
First I need to figure out how to create that so I can eventually put it into a macro.
I loose the zeros and I don't seem to be able to add the comma. It has been a long time since I work anything but simple formulas.
Annelie
You can use this formula in H2, assuming that the heading "acct" is in A1:
=A2&","&TEXT(B2,"0.00")&","&C2&","&TEXT(D2,"ddmmyy")&","&E2&","&F2&","&G2
There are two things that you might need to change, shown in colour:
BLUE: Your profile does not state your location, so your date format may need to be mmddyy
RED: I've assumed that there should be a comma between R and A at the end, but you show a space. If this is not a misprint, then you will need to change the "," to " ".
Hope this helps.
Pete
That worked great in excel. The last two items actually had no space or comma between them.
The result, I pasted values into a new spreadsheet and saved it as tab delimiter text file. When the file is opened in txt format, it put quotation marks in front and at the end.
Have not heard back yet if that is ok.
Last edited by Annelie; 05-10-2019 at 04:16 PM.
Thanks for feeding back.
If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.
Also, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks