Hey, I currently have a program putting strings into Excel as "String + new paragraph character" is there a way to remove this "new paragraph character"? I can't find a VBA substring method or a way to get rid of it. Thanks for any help
-Kyle
Hey, I currently have a program putting strings into Excel as "String + new paragraph character" is there a way to remove this "new paragraph character"? I can't find a VBA substring method or a way to get rid of it. Thanks for any help
-Kyle
have a look at the Clean function
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks