This content has been marked as final.
Show 4 replies

1. Re: Substitute SPACE for any character
philmodjunk Feb 10, 2015 9:17 AM (in response to aspectmedia)Substitute ( 10^Length ( YourTextHere )  1 ; 9 ; " " )
This is adapted from a calculation once posted here by Raybaudi

2. Re: Substitute SPACE for any character
aspectmedia Feb 10, 2015 9:50 AM (in response to aspectmedia)Phil, thank you. This is wonderful, but how does it work? I cannot find any documentation on the web for "^". I know it is in the list of choices in the formula inspector, but ...

3. Re: Substitute SPACE for any character
philmodjunk Feb 10, 2015 2:52 PM (in response to aspectmedia)^ is the exponent operator. 10^2 evaluates as 10 to the power of 2 or 100.
So a 3 character string becomes 10^3. A 4 character string would be 10^4 and so forth. Subtract 1 and 100 becomes 99, 1000 becomes 999 and so forth. Thus, the calculation produces a digit 9 for every character in the string.

4. Re: Substitute SPACE for any character
aspectmedia Feb 10, 2015 6:51 PM (in response to aspectmedia)Brilliant! Thank you.