View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default reference cells when looping

It depends on what you mean.

If you want to extract the characters A-Z and a-z and eliminate everything else,
you could loop through the text and look for those characters.

If you want to keep the first x number of characters (or the last x number of
characters) or even the characters after some indicator (like everything after
the initial hyphen in: xxx-ab23cd), the code would be different.

And what reference do you mean? I'm guessing tcell, but not sure.

Isis wrote:
snipped


Dave,

Thanks for that !

If wanted to get the 'alpha' part of the reference and put it into a
variable, how would I do that ?

Thanks again thats a good problem solved.


--

Dave Peterson