Extract Text with Wildcards

[AMPAllie]

I have a column of project names. Somewhere in that string is the circuit ID. It begins with uppercase "C" and will have 3 OR 4 numbers behind it. Then a space, or a hyphen.  The circuit ID is not in the same place in the string every time.  And it may not be the only "C" or the only set of numbers in the string.
Any ideas on how to extract it from the string?

[KT_Bsmart2gethe]

Hi @AMPAllie,

It'd be great if sample data with sensitive data removed could be provided.

Regards

KT

[AMPAllie]

Here's a sample set. The circuit ID "CXXX" or "CXXXX" can be anywhere in the string.

SDG&E PRiME C448-III

SDG&E PRiME C448-Q

SDG&E PRiME OPS 2021 C1076 C RECON

SDG&E PRiME C448-T

SDG&E PRiME C448-N

SDG&E PRiME OPS 2021 C276 D Recon

SDG&E PRiME C448-YY

SDG&E PRiME OPS 2021 C276 E RECON

SDG&E PRiME OPS 2021 C303 H RECON

SDG&E PRiME OPS 2021 C1483 A RECON