Can some one advise me as to how I can overcome a problem that has recently occurred? I am sent an automatically created report as a .csv file, one of the columns contains both text and numbers, this is copied into another file where the data is concatenated with other information to create a batch file.

I had thought this had been working fine until I found that numbers within the column, which had leading zeros, were now without them. To overcome this I had a leading ‘ (apostrophe) added to the column in the .csv file so it read as text. My problem now is how to I remove the ‘ but maintain the leading zeros when I copy the data over and ensure that the ' is not in the result when I have concatenated the data.

I’ve looked at find and replace, substitute and VBA without success.

Has anyone got a solution?