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.
أكثر...
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.
أكثر...