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

    Substitute SPACE for any character

    aspectmedia

      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.