Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.
2. How do you copy from Excel (see 1 below) and paste into Word (2) WITHOUT seeing the filter button, gridlines, comment notes and more?

Guess and then view answer to see how it can be done!

# International packing code in Excel

The International Packing code is constructed as follows:

• The 1st character and the 4th character is the week of packing but reversed i.e. 0103 would mean week 30 (the 4th character and the 1st character together).
• The 2nd character is the day of week picked (Monday= 1, Sunday =7)
• The 3rd character is a dummy character and can be used by the packing company for their own purposes.

## How to create the International Packing Code in Excel

If you set up the spreadsheet as below, you can enter the Week number and the Day of the week (we have used 0 as the dummy number). To turn it into the Packing Code you would:

• Create column E which uses the LEFT function to extract the 1st character in the week number
• Create column F using the RIGHT function to extract the 2nd character from the week
• Combine the information in the correct order using CONCAT (or CONCATENATE in older versions)
`If you are unfamiliar with LEFT, RIGHT, MID and CONCATENATE you can learn about them here`

## How to decode the International Packing Code in Excel

If you have received the International Packing code and want to (easily) break it down into the week number and day of packing you can do the following:

• Create 4 columns (B, C, D and E) to break up the code to one character per column using LEFT, MID, and RIGHT as shown below
• In column G use CONCATENATE to join character 4 and 1 (in that order) to create the week number.
• You can just use character 2 for the day of the week
`If you are unfamiliar with LEFT, RIGHT, MID and CONCATENATE you can learn about them here`

Want to learn more about Microsoft Excel? If you prefer attending a course and live in South Africa look at the Johannesburg MS Excel 3 Day Advanced Course  or the Cape Town MS Excel 3 Day Advanced training course. If you prefer online learning or live outside South Africa, look at our online MS Excel training courses.