PDA

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



wnazzaro
09-27-2006, 07:34 AM
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
09-27-2006, 07:41 AM
It's a Chr(9)

wnazzaro
09-27-2006, 07:48 AM
It's a Chr(9)
I tried that before I posted, and it didn't work. However now it does.

I feel dumb.

Thanks.