I have a column in excel (2002) of numbers with dashes in them (for example:
04-115-5-0606), and I need to take the dashes out. I'm using the
text-to-columns function, then concatenating it back into one column without
the dashes.
Some of the groupings have leading zeroes. I formatted the destination
cells for the text-to-column part to have the correct number of characters,
so they appear correct when they're split up. When I concatenate, however,
the leading zeroes disappear.
Is there a way to concatenate and keep the leading zeroes? Or is there a
btter way to do this?
Thanks!