VBA solution to finding a string in a cell that is N chrs in length

[Don Iliffe]

I am trying to find a VBA solution to finding a string in a range of cells that is of a specified chrs length.

The purpose is to find, and then copy this string, and all other instances, to another worksheet. The copying part is not a problem, but I cannot come up with a solution that finds a string in the cells that is n chrs in length. (The actual length is nine(9) chrs)

Does anyone have any ideas on this.

 

[Don Iliffe]

Steve the Fish


OK! Found out the issue, it was calling the wrong macro.
Now when I try to call your UDF, sing '=extract_chars(a1)'. I am getting #NAME error

I have put the =extrac_char(a1) in cell B1 as the desired destination cell.

 

[steve the fish]

You would because you missed a 't' and you still need to use ,9

 

[Don Iliffe]

that was my mong typing here, there is a big delay between keyboard and what is appearing on the screen and it sometime misses chars

Where do I put the 9?

Replacing Number of Characters with 9 does not work

 

[steve the fish]

See post number 10:

=extract_chars(A1,9)

 

[Don Iliffe]

That was what I was using, but getting #NAME

Have now inserted a new module and put code there instead of the sheet code and it is working fine now. Tested using short cell data (no 9 char strings) and get a negative as well so all is good.

its taken me 10 mins to get this typed.

Many thanks for that.

 

[steve the fish]

Yes that needs to go in a standard module. It should work. It does for me on your sample.

 

[Don Iliffe]

tyija1995, thanks for your post as well, I am going try this as I can definitely use it. It does not help with my current issue. but I can think a multiple of uses for it. So thanks