Trim function ?

[bflan0524]

i am not sure if this would be a trim function or not. if somebody could help that would be great.
if i have in column A the following 4-Very Satisfied. how would i get that column to just show the 4 in another column?

thank you

 

[hiker95]

@hiker95

Why to go to such lengths?

Aladin Akyurek,

I just displayed other formulae that worked from my archives.