Hi..I'm just discovering the wonders of macros. I have the minimum-est possible programming knowledge. I would greatly appreciate a macro code to tackle this cumbersome task:
Say B1:B10 contains strings 1A-10A in its counting order. (My spreadsheet has 100-1000 of these)
Column A in the same...