I need some guidance/help. I have a spreadsheet that is exported from an instrument that I would like to sort by Vial. Currently the Vial consists of a letter followed by a number. When I sort it I get A,1, A,10, A,11, A,2, A,3 designation but I would like it to be truly sequential A,1, A,2, A,3....A,10, A,11. I think I need to format the number portion to be 2 digits so that it is A,01, A,02 so that it will align how I need it. Is there a function or formula for me to do this? Do I need a macro??? The number of rows can vary but can exceed 10,000 rows. Please help!!!
Thank you in advance
Bookmarks