I have a spreadsheet that has a column of postal codes. The format that is shown now as an example is L7G 5Y3. However, the format I need for Canada Post is L7G5Y3 (so to remove the space between the first 3 characters with the last 3 characters. Is there a way that I can do this without having to go thru 900 lines of this document and manually remove the space between the characters?
To save time and manual entry of long number files. In this case 995 lines would need to be changed removing the space between the first and last three characters.