>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