String Report

[rpadminserver]

Hello all..
I have thousands of records that have descritptions like:
JP-8190 JT-10
This is one cell

In need to pull the 4 numbers after the JP in column b and the 2 or 3 numbers that appear after JT in collumn c.


Thanks all
Rob

 

[Jonmo1]

If the pattern is constant...
Always 4 numbers after JP-
Always the numbers after JT-


Try
=MID(A1,4,4)

and

=MID(A1,FIND("-",A1,4)+1,len(A1))

 

[rpadminserver]

jonmo1.... thanks
The first one works perfectly,

the 2nd one is almost there.


There is a bunch of other information after the JT- (and 2 or 3 numbers). so the result i'm getting from your formula is everything after the JT-, not just the 2 or 3 numbers. Here is a complete example of the cell:

JP-8190 JT-10 (01) COM A TO K3 - (01)GROUND

IF it helps, there will always be a space between the 2 or 3 numbers after the JT- and the first Left Parentheses

 

[Jonmo1]

It will always be either 2 or 3 numbers, no more / no less?
Always a space after the 2/3 numbers?

Try

=TRIM(MID(A1,FIND("-",A1,4)+1,3))

 

[rpadminserver]

FANTASTIC!!!!
Thank you very much!

there is a potental for the number after the jt to be 4 or 5 digits, but that has not happened yet. I'll worry about that when it happens.

Thanks again!

Rob