•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Is there a way I can change every number in a list to add in - to make it easier to read
I have a list of locations in an aisle and the system generates them to look like this picture. I need them to look like this example, 12-01-0A-01 to make it easier to read. Is there anyway I can do this in excel. This shows the aisle (12) the bay (01) the level (0A) and the position (01). Each bay has 4 positions.
[link] [comments]
Want to read more?
Check out the full article on the original site