Sorting Dewey codes in Excel
How do I sort a column where the cells contain both numbers and text eg 398 FOLK, 920 ATT, 942 TUDORS as well as just numbers eg 577, 796.33. I have tried making the cell format text, general and special but none work.
Can I make a custom cell format to cover this (haven’t been able to work out how)?
How do I sort a column where the cells contain both numbers and text eg 398 FOLK, 920 ATT, 942 TUDORS as well as just numbers eg 577, 796.33. I have tried making the cell format text, general and special but none work.Can I make a custom cell format to cover this (haven’t been able to work out how)? Read More