Hello Excelperts,
I find myself in a bit of a conundrum and looking for your help and expertise to learn how to pull a substring from a cell of variable length string.
From the transcript column A1, I have variable length transcript string, what I am looking to extract is the name of the person who is chatting with (highlighted in Red below). The text highlighted in GREEN is always consistent, so I need to pull the substring after the "You are now chatting with " and before the Period at the end of that line.
How would I go about doing this? Any help would be greatly appreciated!!
<tbody>
</tbody>
I find myself in a bit of a conundrum and looking for your help and expertise to learn how to pull a substring from a cell of variable length string.
From the transcript column A1, I have variable length transcript string, what I am looking to extract is the name of the person who is chatting with (highlighted in Red below). The text highlighted in GREEN is always consistent, so I need to pull the substring after the "You are now chatting with " and before the Period at the end of that line.
How would I go about doing this? Any help would be greatly appreciated!!
Transcript | Name |
14:09:54 info: Thank you for choosing to chat with us. An agent will be with you shortly. 14:09:56 info: 14:09:56 info: 14:09:56 info: You are now chatting with Jose C. 14:10:10 Jose: <span>Hi, I'm Jose C, I am glad to help you. | Jose C |
<tbody>
</tbody>