Forum Discussion

Chrismultiair9810's avatar
Chrismultiair9810
Copper Contributor
Nov 16, 2023
Solved

sequence of warehouse locations

Hi all, i want to creat a sequence of letter-number combination Starting with AA01A01 until AA01A10 Then AA01B01 until AA01B10 further on until level E (AA01E10), witch is the last for rack AA , 1...
User Adoption
  • Lorenzo's avatar
    Lorenzo
    Nov 16, 2023

    Chrismultiair9810 You're welcome

    To help others with a similar challenge could you take a few seconds to click on Mark as response at the bottom of the solution you adopted?

     

    Thanks & Nice EOD...

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Nov 16, 2023

Chrismultiair9810 You can do this without making it too complicated. It seems that the first two elements are variable (AA and 01). After that you have groups A through E with serial numbers 01 to 10. That makes 50 location codes in total. Not sure why you came to 100.

 

The attached workbook creates these 50 codes based on the structure described above. I used both TEXTJOIN and CONCAT. See which one works best for you.

 

Change the variables in the highlighted cells to generate 50 codes more. Copy/Paste Values for all options and to create your 300 (or 600) location codes. Will take max two minutes.

  • Chrismultiair9810's avatar
    Chrismultiair9810
    Copper Contributor
    Nov 16, 2023
    A big thank you, for the tips and tricks.
    Really appreciated.
    Kind Regards,

Resources