How to separate IDs from the text

Question

Hi,

Please help in separating the IDs in separate column from the text. attaching the sample working file on which I worked manully 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 comes after (channelMsgId":"wamid) in "A "column that needs to be separated which ends with ==

sample.xlsx

Qiu · Accepted Answer

@shahnawaz_khan 
I think we can use RegEx as below.

AlexanderVM · Accepted Answer

The solutions posted here are already amazing and mine is a little repetitive but sharing anyway.