SOLVED

Extracting certain data from a cell

%3CLINGO-SUB%20id%3D%22lingo-sub-2227297%22%20slang%3D%22en-US%22%3EExtracting%20certain%20data%20from%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2227297%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWorking%20on%20a%20large%20report%20and%20need%20to%20extract%20specific%20data%20from%20a%20cell%2C%20example%20below%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E72477SN15296CD102394.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20extract%20the%20%22Stock%20Number%22%20which%20is%20SN15296.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHelp!%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2227297%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi All,

 

Working on a large report and need to extract specific data from a cell, example below:

 

72477SN15296CD102394.

 

I need to extract the "Stock Number" which is SN15296.

 

Help!

 

3 Replies
best response confirmed by Shane1408 (New Contributor)
Solution
=MID(A7,FIND("SN",A7),7)

I would be happy to know if I could help.

Nikolino
I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here
Nikolino, you legend!

Thanks so much!
I was pleased that I could help you.

You are welcome