The Pit # column was formatted into a 4 digit number to maintain the leading zeros (all pit numbers are 4 digit numbers). However the data needs to be manipulated to combine columns pit number and pit name (as seen in A32 on SA1 workbook). Is there an easy way to convert pit number column into text while maintaining the leading zeros?
Solved by T. C. in 25 mins