I have an excel, the data has two $ , when I read it using pandas, it will convert them to a very special text style.

```
import pandas as pd
df = pd.DataFrame({ 'Bid-Ask':['$185.25 - $186.10','$10.85 - $11.10','$14.70 - $15.10']})

```

[![my excel](https://i.stack.imgur.com/HTAE4.png)](https://i.stack.imgur.com/HTAE4.png)

after pd.read\_excel

[![after pd.read_excel](https://i.stack.imgur.com/OK3rT.png)](https://i.stack.imgur.com/OK3rT.png)

```
df['Bid'] = df['Bid-Ask'].str.split('−').str[0]

```

above code doesn't work due to $ make my string into a special style text.the Split function doesn't work.

my expected result

[![enter image description here](https://i.stack.imgur.com/ZOzVM.png)](https://i.stack.imgur.com/ZOzVM.png)