•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
Tagged with
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#enterprise-level spreadsheet solutions
#Excel
#list
#locations
#aisle
#bay
#level
#position
#readability
#format
#system
#numbers
#positions
#generate
#data
#example