Remove Characters Expect

[mdo8105]

I've attempted to search online, but with zero luck. Is there a way to remove all characters in a string except a specified string? My string is NP. I have a column that will have different variations of NP. For example CRNP or CRNP MSN and my end goal is remove all characters and just end up with NP.

Thank you,

 

[shg]

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]

A​

[/td][td="bgcolor:#C0C0C0"]

B​

[/td][td="bgcolor:#C0C0C0"]

C​

[/td][/tr][tr][td="bgcolor:#C0C0C0"]

1​

[/td][td]CRNP[/td][td="bgcolor:#CCFFCC"]NP[/td][td="bgcolor:#CCFFCC"]B1: =IF(COUNTIF(A1, "*NP*"), "NP", "")[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

2​

[/td][td]CRNP MSN[/td][td="bgcolor:#CCFFCC"]NP[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

3​

[/td][td]Bob[/td][td="bgcolor:#CCFFCC"][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

4​

[/td][td]NP2[/td][td="bgcolor:#CCFFCC"]NP[/td][td][/td][/tr]
[/table]

 

[mdo8105]

You are awesome! Thank you so much.

 

[shg]

You're welcome.