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:
01386848
Vues:
56
>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?

Interesting question. We can not use replace function since there is nothing to replace
http://www.techonthenet.com/excel/formulas/replace.php. Looks like we have to grab each character for the length of the string, substruct a character, then add a space.

Do you have to do it in Excel with a formula or you can get the data into the table and manipulate data there?
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform