delete every other Char(10)

[ferrigeu]

hi folks,
I get a daily file that has Alpha/Numeric content. to separate various entries, the originators add Char(10), at times two of them.
looking for a formula that will find the second, fourth, sixth, eights, etc. Char(10) and replace it with "".
it should not return an error is there are only 2 instances of Char(10) to replace.
any thoughts?

 

[Norie]

You could try this.

=SUBSTITUTE(A1, CHAR(10)&CHAR(10), CHAR(10))

 

[ferrigeu]

so often the simple approach is the best...
thks Norie!!
this works super!