-
Solved: Parsing text in a cell [Chr(10) & Chr(13)]
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
-
-
Originally Posted by
xld
It's a Chr(9)
I tried that before I posted, and it didn't work. However now it does.
I feel dumb.
Thanks.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules