Using Right() to pull number out of PM#####

[zoog25]

Hello all,

I have a log that uses codes to designate a project number. Common style is two letter followed by a string of number. The situation is that i using a macro to run a special report. What i need is to pull the string of numbers of the the coded number in order to run coding. For example i have PM1952. I need to pull the 1952 in order of the string. I know i can use the Right () function in coding but how do i get it to pull all the numbers and stop at the first letter. In this case it would be M. Thank you for any help. Note that the code is held under the following code TPws.Cells(rw,"G"). That is how i have the coding find the particular code. active row, column G.

 

[Fluff]

If you always have two letters at the start you can use

Mid(TPws.Cells(rw,"G"),3)

If you could have any number of letters at the start, could you post some examples? It maybe you'd be better of using RegEx, but that is not something I know about.

 

[zoog25]

As of right now, it's always going to be two letters at the beginning. I believe the codes will be TR, PM, PW, or ST. the issue is the numerical string can be anywhere from 1 number to infinite. I'm setting up something up to work and the code won't repeat so it will keep going. Currently one code is at a 4 digit number and another is at a 6 digit number.

 

[Fluff]

In that case you can use Mid as I showed. If you don't specify the number of characters to return it will return everything after the 2nd character.

 

[zoog25]

Thank you Fluff.

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Dave Patton]

2 letter prefix

T202010a.xlsm
	A	B	C
1
2		PM1952	1952
3		aa195254	195254
4
2c

Cell Formulas
Range	Formula
C2:C3	C2	=MID(B2,3,99)