>Hi!!! Just thought of posting this here..
>
>I am working with an excel file. I need to put spaces in between characters.
>
>I want to turn 123-456-789 to 1 2 3 4 5 6 7 8 9
>
>Can you help me?
Something like this returns SSN - no dashes - spaced out...
=MID(A1,1,1)&" "&MID(A1,2,1)&" "&MID(A1,3,1)&" "&MID(A1,5,1)&" "&MID(A1,6,1)&" "&MID(A1,8,1)&" "&MID(A1,9,1)&" "&MID(A1,10,1)&" "&MID(A1,11,1)&" "
Where A1 SSN
Edgar L. Bolton, B.S. B.B.A.