How to Use Excel LEFT to Extract the First Three Characters
Use =LEFT(A2,3) to take the first three characters of a warehouse bin code. In your Excel workbook (.xlsx) in Cue Office, store 007241 as text so the formula returns 007. A two-character code like Q7 stays as it is.
How Do You Keep the Leading Zeros in 007241?
Create a new spreadsheet in Cue Office and paste the practice data into A1. Leave A2 blank for now. Select A2, choose Text from the number format dropdown on the Home tab, then type 007241 and press Enter.
Check A2 or the formula bar to make sure the stored code is 007241. If you see only 7241, check the bin label and re-enter the full code with A2 set to Text. LEFT can only use the characters that are already there.
Click B2 and paste all four formula lines at once. In =LEFT(A2,3), A2 is the source cell and 3 is how many characters to take from its left side. Each of the other formulas reads the bin code on its own row.
=LEFT(A2,3) =LEFT(A3,3) =LEFT(A4,3) =LEFT(A5,3)
Does LEFT Pad Short Bin Codes?
Click B4 to check the result of =LEFT(A4,3). A4 contains Q7, so the formula returns both characters. If your pick list requires a three-character zone code, check which zone Q7 maps to before assuming it needs a zero.
Click Save As on the top-left toolbar to save a copy, then close and reopen the newly saved file. Verify that B2:B5 display 007, R42, Q7, and B19 in order.
How Can Cue AI Create Prefixes That Update?
Open a copy where the Prefix column has not been filled yet, select B2, and click Cue AI. In your prompt, specify where the source codes are, which cells to fill, and how to handle zeros and short codes.
For each warehouse bin code in A2:A5, take its first three characters and put the corresponding result in B2:B5. Keep leading zeros, and return the whole code if it has fewer than three characters. Make the prefixes update whenever a source code changes. Edit only B2:B5 and leave all source codes and headers unchanged.
Cue AI wrote four LEFT formulas in B2:B5 and left the source codes and headers unchanged. Click Save As to save a copy. Close and reopen it, then check the four prefixes and the original codes. Click B2 to see =LEFT(A2,3) in the formula bar.
In the reopened copy, change A2 from 007241 to 009864. B2 immediately updates from 007 to 009, confirming that the prefix updates with the source code.
Practice with Four Bin Codes
Show the full example
Paste the data into A1. Leave A2 blank, format it as Text, and then enter 007241. Back to the formula steps.
Bin code Prefix R42-18 Q7 B19-04
Use Prefixes to Find the Zone and Full Codes to Find the Bin
When bin assignments change, ask Cue AI to pull prefixes from the new list into a helper column and keep the full codes. Before handing the list to the next shift, spot-check a code with leading zeros and one shorter than three characters. Pickers can use the prefix to find the zone, then use the full code to find the bin.
If the next shift gets a PDF (.pdf) pick list, open it for free in Cue Office and compare its full bin codes with the Excel workbook (.xlsx). If a bin has a new code in the workbook and still has its old label, record both codes in a Word handoff sheet (.docx) so the next crew can find the bin and verify the new code. When a whole row of racks is being relabeled, use the free presentation editor in Cue Office to make a PowerPoint slide (.pptx) showing which old zone codes map to which new ones.