Solved: Parsing text in a cell [Chr(10) & Chr(13)]

[wnazzaro]

I've attached my data with the macro so you can see the problem. When the macro runs it checks for any carriage returns or line feeds and either removes them, or uses them to split the address line into two lines. However the third row of data has an extra character that I am not able to identify and remove. It's not Chr(9) or (10) or (13) unless I've made an error in my Do...Loop (highly possible).

As always, any and all help is appreciated.

Best regards,
Bill

[Bob Phillips]

It's a Chr(9)

[wnazzaro]

It's a Chr(9)

I tried that before I posted, and it didn't work. However now it does.

I feel dumb.

Thanks.