advanced excel ms training - reformat postcodes

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel ms training - Reformat postcodes

advanced excel ms training - Reformat postcodes

resolvedResolved · Low Priority · Version Standard

Christine has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Reformat postcodes

Postcodes on my database are in the format SW18 2PU. I receive excel spreadsheets with postcoded data from other organisations that I need to match to my own data. Postcodes arrive in various formats e.g. SW182PU, SW18-2PU, SW18_2PU. How can I change them into the format I need? Bear in mind the postcodes could be of different lengths e.g. SW8 2LL.

RE: Reformat postcodes

Hi Christina

Thanks for your question.

I think you would need to set a custom format for this. There are various symbols that you can use as part of a custom format (as you will see if you go to Format - Cells - Number and select Custom from the Categories list).

I would suggest going to Excel Help and looking up custom number formatting to find out what all the various symbols stand for then create you own custom number format for the postcodes.

I hope you enjoyed your training today and have a good weekend.
Amanda


 

Excel tip:

Viewing Many Worksheets

If there are more worksheets in your workbook than there is room to show all their tabs at the bottom of the screen - Right click on the navigation arrows. A list of all your worksheets is shown. You just click on the one that you want to access. If you have more than 15 worksheets, select in the list and choose your worksheet from hundreds.

View all Excel hints and tips


Server loaded in 0.09 secs.