I need to insert two "-" into a column of cells in different locations within the same number. What is the best way to do this?
I have figured out how to get one of the hyphens in using the formula =REPLACE(A2,7,0,"-") but I can't figure out how to get the second hyphen in.
Example:
Existing information in cell:
123456789
Needs to be:
123456-78-9
Thanks for all you help!
I have figured out how to get one of the hyphens in using the formula =REPLACE(A2,7,0,"-") but I can't figure out how to get the second hyphen in.
Example:
Existing information in cell:
123456789
Needs to be:
123456-78-9
Thanks for all you help!