SPLIT

to make split data in one column into two

e.g 41h 58m

then =SPLIT(G2," ") {G2 is cell number}

it will give

41h 58m

Further =SPLIT(Z2,"h")

Z2 is cell number

it will give

41 h

UNIQUE that gives data without blank spaces.

=UNIQUE(FILTER(Raaw_data!E:E,Raaw_data!E:E<>""))

it will exclude all blank columns


and if you want to sort then just use sort

=sort(UNIQUE(FILTER(Raaw_data!E:E,Raaw_data!E:E<>"")))

it will arrange data alphabetically

How to filter special Character from a Column in Google Sheet

=REGEXREPLACE(Raaw_data!H1622, "[A-Za-z0-9]", "")

it will return any special character within the specific cell,

I got return

-