CODE EXAMPLE FOR PYTHON

python - removeempy space in a cell

data = pd.DataFrame({'values': ['   ABC   ', '   DEF', '  GHI  ']})
      values
0     ABC   
1        DEF
2      GHI  

data['values'].str.strip()
0    ABC
1    DEF
2    GHI