Percentage to value in Excel

=SUBSTITUTE(SUBSTITUTE(U4; " %"; ""); "."; ",") * 1