Hi,
you can get the numbers but the text, a solution is to use text to columns
and then insert columns everyt three other

"Aaron H" wrote:

Hi guys, is there a way to convert the following
123456789 to 123-456-789
or
abcdefghi to abc-def-ghi
I need to convert a long list of serial numbers so I can look for them, but
doing it one by one will take me an eternity.

Thanks