Extract specific characters from cell onto another cell? [on hold]

المشرف العام

Administrator
طاقم الإدارة
I have an excel spreadsheet with several hundreds of rows of values in the following format:

533-422-09-00

I would like to replace them with the hyphens removed as such:

5334220900

Is there some function in excel that allows us to edit inside strings or sets of values? All the values have the same number of digits and I would prefer not to have to rewrite all 565 values by hand.



أكثر...
 
أعلى