removing dashes from numbers
Highlight the column and do Find & Replace (CTRL-H):
Find What: -
Replace with: (leave empty)
Click Replace All.
Note that if you have "numbers" like 0012-3456, you will lose the
leading zeros and end up with 123456.
Hope this helps.
Pete
On Jun 21, 4:39 pm, "Pat Jones" wrote:
Hi;
I have a long column of numbers that contain "-" (I call them dashes). I
need to remove the dashes from these 3000+ numbers. Is there a way to
automate this process?
Thanks;
Pat
|