I am trying to create a custom sku for inventory that will consist of 3 pieces of information.
Book #
Page #
Card #
For Book 1, Page 1, Card 9 the sku should appear as B1P1C9.
There are 20 books, each Book will have a maximum of 100 pages, each page will have a maximum 9 cards.
I'd like to create a spreadsheet with a formula that could create this output for me so I don't need to manually create this. Does anyone have any suggestions?
Bookmarks