I need some advice with an IF Formula

[savini101]

I have a cell containing the following data,

finish_size=3898by8268|type=true|media=65Silk|printType=44|client=Cnv|lamination=UV|skuAndAttr=TriFoldCard_3.898by8.268_44_65Silk_UV_Cnv|orientation=landscape|orderId=PAEtRUpsYZY|catalog_size=297 x 210mm|catalog_media=150_Silk

I need a formula that if this cell contains the text "catalog_size=" the to return all the text to the right of this.

Anyone advice please.

[#2]

@savini101 

Let's say the cell with the text is A1. The formula could be:

=IFERROR(MID(A1,FIND("catalog_size=",A1)+LEN("catalog_size="),1000),"")

If you have Microsoft 365/Office 2021, you can use

=LET(s,"catalog_size=",IFERROR(MID(A1,FIND(s,A1)+LEN(s),1000),""))