G
Guest
Hello all. I would like to insert a "-" into a column of numbers after the
5th digit each time. The 1st 5 digits will not always be the same, obviously
and there are either 6 or 7 digits total in each number.
I was trying to do this via find and replace, but I can't seem to figure out
a good way.
For example: 7000111 I would like to be 70001-11
Thanks in advance!!!!
5th digit each time. The 1st 5 digits will not always be the same, obviously
and there are either 6 or 7 digits total in each number.
I was trying to do this via find and replace, but I can't seem to figure out
a good way.
For example: 7000111 I would like to be 70001-11
Thanks in advance!!!!