Extracting certain data from a cell

[Shane1408]

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! :)

[#2 · Accepted 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

[#3]

Nikolino, you legend!

Thanks so much!

[#4]

I was pleased that I could help you.

You are welcome