Excel: find position of character with specific format in a cell
I have a column of cells with text which I want to sort alphabetically. But not all cells should be sorted by their first characters. In these cells the character by which they should be sorted is formatted with a (single) underline.
Now I want to create an auxiliary column which contains only