I have a spread sheet to process which is a couple of thoushand lines long.
in column B it has a clothing description including size is there a formula i can use to take the size from that column and place it in Column N
Sizes are XS,S,M,L,XL,XXL,XXXL
Thanks

