E
Erika
I have a spreadsheet with a column of account numbers, the
account numbers all look like this
53-1234
53-12345
53-123
How can I remove the - and insert enough zeros in the
place of the - so there are 8 characters in the account
field. In other words I would have
53001234
53012345
53000123
account numbers all look like this
53-1234
53-12345
53-123
How can I remove the - and insert enough zeros in the
place of the - so there are 8 characters in the account
field. In other words I would have
53001234
53012345
53000123