Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Ella Campbell   on Oct 05 In MS Office Category.

  
Question Answered By: Shayne Anderson   on Oct 05

I really just threw it in for novelty... but it is fast. I like
SPLIT. I use it a lot in parsing and so on. Replace is fast too. I like the
REPLACE as well but I'd prob put it in a 1 to 5 FOR.. NEXT to get rid of
doubles spaces. The SPLIT/JOIN suffers the same prob.

But I think you're right ... The REPLACE is probably the simplest.

The loop through for ASCII codes is the best I think. In the one where I
passed a string I did an INSTR on the passed list for the ascii code of the
character. It meant I could pass an OPTIONAL string of ASCII codes like
"20,13,10".

I had a big problem  once with "smart" quotes, and that's what I used that
for.

Share: 

 

This Question has 6 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Remove the spaces between characters in VBA Or get search suggestion and latest updates.


Tagged: