How separate channel ID

Question

Hi,

Please help in separating the IDs in separate column from the text. attaching the sample working file on which I worked manually for better understanding where i have separated the IDs in "B" column from the "A", also highlighted in bold which we have to separate.

Text which starts (channelMsgId) like below, in "A "column that needs to be separated which ends with ==

channelMsgId":"wamid.HBgMOTE5NjUyMDQyNTU1FQIAERgSQjUxQ0YzMEU0OEZERjVEOTI0AA

sample.xlsx

Qiu · Accepted Answer

@shahnawaz_khan 
I use the RegEx as below.