4 Replies Latest reply on Feb 10, 2015 6:51 PM by aspectmedia

# Substitute SPACE for any character

### Title

Substitute SPACE for any character

### Post

I'm trying to make a simple solution to substituting any character (alpha or numeric) with a space. For example: I have 15 characters (letters, numbers, upper case lower case, etc) in a string and I would like to end up with 15 spaces.

Can't seem to find something to represent all numbers and letters to use in a Substitute() formula.

• ###### 1. Re: Substitute SPACE for any character

Substitute ( 10^Length ( YourTextHere ) - 1 ; 9 ; " " )

This is adapted from a calculation once posted here by Raybaudi

• ###### 2. Re: Substitute SPACE for any character

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

^ 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

Brilliant! Thank you.