How would I apply the "left" formula with 5 characters to a column with the header "ValueCol"

Thank you for your time