Formula to get exact part number

D

Docharding

New member
Joined
Dec 11, 2018
Messages
7
Reaction score
0
Points
1
Excel Version(s)
2016
Hi all,

Please could some one help me with a formula to get the exact part number from a line of text. The part number I need is underlined. The second photo is what I would like to achieve. I hope this makes sense.

Regards
5bf27a05dcfdd76cd21e644350d79bde.jpg
3c0f0ca8d2abc38614f334870e007f80.jpg


Sent from my SM-G965F using Tapatalk
 
What are the rules for the data that can be used? Does SP ever appear anywhere else in the data? Does the data always end with the part number followed by either "TT)" or just ")"? Is the part number always SP and three digits?
 
Perhaps this formula
Code: 
=MID(A1;FIND("SP";A1;1);5)
 
JoePublic said:
What are the rules for the data that can be used? Does SP ever appear anywhere else in the data? Does the data always end with the part number followed by either "TT)" or just ")"? Is the part number always SP and three digits?
Click to expand...
The part number is always SP and 3 digits, after the part number varies unfortunately

Sent from my SM-G965F using Tapatalk
 
Or another version:

=TRIM(LEFT(RIGHT(" "&SUBSTITUTE(TRIM(A1)," ",REPT(" ",60)),120),60))
 
navic said:
Perhaps this formula
Code: 
=MID(A1;FIND("SP";A1;1);5)
Click to expand...
Thank you this worked perfectly. However I have now found that there are other part numbers that start with "SL" or "ST" so is there a sway that I can use an and or on the find?

Sent from my SM-G965F using Tapatalk
 
You must log in or register to reply here.
Back
Top