SOLVED

Extracting certain data from a cell

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