How do I do this in excel ....

[stuartbrisgel]

Hello Y'all



I am trying to extract data from a cell to fill another


Example


in CELL D220 = Black - (Part ID: 4278910)


I want in CELL C220= 4278910


How to extract?

 

[JoeMo]

This returns your part ID as text.

=MID(D220,SEARCH("ID:",D220)+4,LEN(D220)-(SEARCH("ID:",D220)+4))

If you want it returned as a number, use this:

=MID(D220,SEARCH("ID:",D220)+4,LEN(D220)-(SEARCH("ID:",D220)+4))*1

 

[stuartbrisgel]

Thank you could not figure it for the life of me