I need to remove a hyphen from a number in a cell, move down one cell and repeat-15000 times. The format will always be XX-XXXX. I need to end up with XXXXXX as the result. I used to be able to do this in Lotus 123, but that's dating me. Thanks in advance.
Bookmarks