I have tried to split the cell though it it removes all S's in words, I only require the last letters in a new cell. IE XS, L, M, S etc and all words are not the same length.
Not so up with formulas or can it done easily with Text to columns?


Sammy Dress Porcini XS
Amelia Cowl Jacket
Billie Blouse L
Billie Blouse L
Billie Blouse M
Billie Blouse S
Billie Blouse XS

Cheers