Hi All
I'm new to this site, just joined up.
I have a problem that frustrates me.
In the UK we have a post code system that is generally in the format say, CF45 9QG as in LLNN NLL, now there are exceptions to the rule in certain part of the country but the worse scenario is LN NLL. (where L = letter & N= number)
Basically my problem is lazy people who enter post codes in all sorts of formats for example cf459Qg or b19cF (this would be LN NLL as in B1 9CF) into an on line application. The output from the on line application is sent to me in excel as one line for each submission and I cant affect how the information comes to me.
I then import the information into a worksheet where the information is then sent to the rest of the other sheets in the workbook, so far so good. One of the sheets in the workbook creates an invoice who's number is based on the post code. I can sort the case out with the "upper" function but the problem is the gap between the numbers.
What I think I need is a formula that puts in the gap for me which is always 3 digitd from the RHS
I'm open to any suggestions, it seems a shame to have to import the information and then have to go in and check/edit this for every submission.
Kind regards
Paul
Bookmarks