How to retrieve a particular value from multiple lines of a field in Excel?

[excelhelp2045]

For an example, my input strings of a field in Excel as follow:

"
Telemanager Cancel VPN token
Service ID: 000156589739

Assigned to employee : XXX - XXX, XXX ; XXX - XXX & XXX

Disconnect Service : VPN
"

I need to retrieve just the number 000156589739 which is located next to "Service ID:"

[oeldere]

a2=MID(A1,SEARCH("Service ID:",A1,1)+12,12)

[excelhelp2045]

Thanks so much oeldere. You have SOLVED my query perfectly.

[oeldere]

You're welcome. We appreciate the feedback!

If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.