Substitute ( 10^Length ( YourTextHere ) - 1 ; 9 ; " " )
This is adapted from a calculation once posted here by Raybaudi
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 ...
^ 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.
Brilliant! Thank you.