title: How to remove certain characters from cell on Excel
body: <p>I am new to python and I am trying to run a program that runs down a list of values on Excel, and removes the "^" character from every index. For example, if i have a column that has the following values (MS144573^, MS655072^, MS655282^, MS655177^, MS655073^) I would like each value to be replaced to (MS144573, MS655072, MS655282, MS655177, MS655073). </p>
  
  <p>I am using the Openpyxl module.</p>
  
  <p>I cannot identify whether cells in Excel are strings, are characters. Any ideas?</p>
  
  <p>i have tried the following code:</p>
  
  <pre><code>import openpyxl
  from openpyxl import workbook
  path = "C:/Users/x/Desktop/x/x.xlsx"
  wb = openpyxl.load_workbook(path)
  sheet_read = wb.get_sheet_by_name("report")
  sheet_write = wb.active
  
  
  for i in range(1, 10):
   x = sheet_write.cell(row = i, column = 1).value
   y = len(x)
   if x[y] == '^':
      x = x[:y-1]
  </code></pre>
  
  <p>But i get this error:</p>
  
  <p>^ y = len(x)
  TypeError: object of type 'NoneType' has no len()`</p>