Find and replace function doesnt work

[Yamasaki450]

Hi guys i need some help.

Im trying to remove dash (or minus symbols) with find and replace function but it doesnt work... I get some weird numbers instead of removing dashes...

Is there any other way to remove them?

It looks like this:

 

[Legacy 143009]

In the picture, there are format buttons. Click them and select "Text" or "Number" before replace.
If this doesn't work, first replace your data. Close Find&Replace window. Select your changed column and go to number format section on the top menu. Change "General" to "Text" or "Number".

 

[Yamasaki450]

It works... Thanks a lot.