Help extracting certain portion of a cell

Hi,

Hoping someone can help a newbie here... I have attached a file we need to format and instructions below of what is required. I don't think it's complex, just need to know the right formulas and approach to use.

What we need:

1. Each evening we export the card payments for that day from our database into an Excel spread sheet. The format of the data exported can be seen in the "Transactions" worksheet of the attached document.

2. At the moment we physically type each transaction, one by one, into the system we use. What we want to do is simply upload a CSV batch file onto our card processors website. In order to do this our data needs to be in a format requested by the card processor. This format is shown in the "Batch" worksheet of the attached document.

3. I have added comments to explain the "changes" that need to be made to the data contained in the Transactions" worksheet when moved to the corresponding cells in the "Batch" worksheet.

4. Some data is semi-permanent and pulled from the "Field Settings" worksheet.

5. So what we require is a small program/formulasor macro that will populate the "Batch" worksheet cells in the correct format based on what data we have placed into the "Transactions" worksheet. We will then save the "Batch" worksheet as a CSV file and upload it to the card processors website.

Please would some excel wizard be able to help?

Thanks

Hi -

Try the attached.

Hope that helps.

Looks like Harribone and I had the same ideas. I used RIGHT and LEFT string functions to extract the date to a four digit format so you can go ahead and use that.

Good luck.

Thank you to both you chaps. Works perfectly! You have just saved me hours of work :-)
Really appreciate it.