I have excel data which I need sorted alphabetically.
Data is in hebrew
is there a way to get it to sort
יג, יד, טו, טז, יז...
(I'd try to create a unique order list, kind of 'sort array' then sort by that column, but I think that'll only work if the entire cell is the specific item match. here I need it to treat it that way 'alphabetically'-where it's the beginning of a larger string of data (e.g. טז,כ comes after יד, ח)