Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Working with text in Excel
Message
 
 
À
10/03/2009 01:38:04
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
01386833
Message ID:
01386874
Vues:
52
>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform