Extract special Textblock from String

[Stefan_Sand]

Hello,

i have a huge list of Booked times for a customer, and some of the booked hours correspond to a special ticket number.
The problem of the text is, that the ticketnumber is standing wherever the tester and developer mentions it.

But the certain string always starts with CC-. Is there a formula to get the string containig always combinations of thext and text like:
CC-35293-D9G5 out of it?

Stefan

Text from Ticketlist.xlsx

[SpeakEasy]

Something like

=MID(A18,SEARCH("CC",A18),13)

[Stefan_Sand]

thank you, cool.

[DocAElstein]

Hi
Just a quick heads up: I think the formula will error on those cells not containing CC. (In the uploaded file some cells don’t contain a CC) I don't know if that is of concern?, - so just mentioning it in case.
Alan

[snb]

Code: Select all

Sub M_snb()
   columns(1).replace "*CC-","CC-"
   columns(1).replace " *",""
End Sub

You can do this manually too.

[Stefan_Sand]

cool thanks