Right / Left & Len function

[mrpudley]

Hello all,

I am trying to extract characters 2 to 6 from the right of a field. The left characters are a user's name and vary quite a bit. The code I am trying to extract is 5 characters in between (). For example my list will be filled with records like this: John Smith (PQ123) or Susan L. Smith (QW321). In these two instance I would like to extract PQ123 and QW321

I have tried various formulae but no luck.

Any help will be appreciated!

Thanks,

Brent

 

[SpillerBD]

=mid(a1,len(a1)-6,5)

 

[barry houdini]

Hello Brent, try this formula

=MID(A1,LEN(A1)-5,5)

 

[mrpudley]

Hello Brent, try this formula

=MID(A1,LEN(A1)-5,5)

Thanks to you both. It worked perfectly!

Now I can conquer the world.

Cheers,

Brent