G
Guest
I have a column of numbers, all 6 digit. Some of the numbers are six digit
with a dash in between the third and fourth digit
Ex.
123-456
122-451
122771
122458
233-564
....and so on
Is there a way to remove the dashes from these numbers that have dashes and
leave the other ones alone? What I want is this column to not have any
dashes.
is concentate the formula to use??
Thanks
with a dash in between the third and fourth digit
Ex.
123-456
122-451
122771
122458
233-564
....and so on
Is there a way to remove the dashes from these numbers that have dashes and
leave the other ones alone? What I want is this column to not have any
dashes.
is concentate the formula to use??
Thanks