Thread
:
Excel format conversion
View Single Post
#
4
May 20th, 2010, 07:05 PM posted to microsoft.public.excel.newusers
John
external usenet poster
Posts: 563
Excel format conversion
Hi Aaron
This works for numbers : =LEFT(A1,3)&-MID(A1,5,3)&-RIGHT(A1,3)
This one works for text and numbers, but your numbers are changed to text.
=LEFT(A2,3)&"-"&MID(A2,5,3)&"-"&RIGHT(A2,3)
HTH
John
"Aaron H" Aaron
wrote in message
...
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
John
View Public Profile
View message headers
Find all posts by John
Find all threads started by John