I have a single column of data containing variable length text strings. In
some of the data, characters repeat sequentially. For example AABBCCDD
I need a function or formula that removes sequential repeats.

if
input: AABBCC output: ABC
input: AAAAAA output: A
input: AAABBC output: ABC
input: ABCDEF output: ABCDEF
input: BAAAAB output: BAB
input: DD output: D

Any suggestions will be greatly appreciated!

--
jake