0 Replies Latest reply: Feb 18, 2009 2:02 PM by drobert _ RSS

    Removing embedded blanks

    drobert _

      I have a value that I extract from a report which may contain embedded blanks that I need to remove. I want to create a formula that contain the value without the repeated blanks, but I can't figure out a function that would do this for me other then using R/LSplit into multiple pieces and pasting them back together.  Is there a better way to do this?:confused:

       

      Ex:

      This is        a     Test

      This      is    another    longer      line   with    more       text

      /code