You need to create a formula in the next column, that uses the LEN and LEFT functions. find the length, subtract 1. copy formula down the new column, if correctly done, then copy the whole new column and paste back as 'Paste Special' and select value.
This will turn the formula into the text value
Then delete the original column
If any of that sounds too
then I'll give you more detail
lightray