Linker IT Software
Order Home
menubar-top-links menubar-top-rechts
SQL*XL: Database to Excel bridge ExcelLock: Lock and secure your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe
Home Products litLIB Help String functions

Buy now

Download now

LITlib - Excel Power Functions Pack
 
Add-in for Excel that adds additional cell functions to Excel.

litLIB Help - DeDup function
litLIB Help
Product pages :
litLIB
Quick links:
help index
forums

String - DeDup

Syntax:
= DeDup(Text [, Character] )

Description:
Deduplicates repeating characters and replaces them with a single character.  

Text : string to process
Character : characters to deduplicate (" " is the default)

Example:
Remove duplicated spaces from the string "hello                world":
=DeDup("hello                world")
returns: hello world

Remove duplicated exclamation marks from the string "This is great!!!!!!!!!!!":
=DeDup("This is great!!!!!!!!!!!", "!")
returns:
This is great!

 

litLIB