SQUEEZE

The SQUEEZE function removes consecutive duplicate occurrences of a specified character or characters from a text item.

Syntax:
SQUEEZE ( single-text-item , single-text-item )
Meaning:
SQUEEZE ( text_to_squeeze , duplicate_characters_to_remove )
Returns:
A single text item

SQUEEZE returns a text item with all the consecutive duplicates of duplicate_characters_to_remove removed from text_to_squeeze.

Examples

  • SQUEEZE ( "AB CDE F", " " )

    Returns: AB CDE F

  • SQUEEZE ( "Connolly", "n")

    Returns: Conolly

Related functions

  • LEAVEALPHA
  • LEAVEALPHANUM
  • LEAVENUM
  • LEAVEPRINT
  • SUBSTITUTE

Feedback