extract word from text

[Afarag]

Dears,

i seek for a function could help me in extracting a name form a text like

text:
[11:29:15] Chat queued to Live Chat Support Amr Nasr

name: Amr Nasr

need to extract the names from this text,
the attached file contain 2 tables,
the first have a data that need the extraction
the 2nd: have the name that want to import

Thanks a lot,

 

[Somendra Misra]

Hi Afarag,

See the file, column E Has formula, I am not sure about your Table2.

Regards,

 

[Steve May]

HI,

It seems that the start text in each cell of column D is the same, i.e 45 characters long, so you can use the MID function to "extract" everything AFTER the 45th character. which would show as follows (for the 1st line of your table, then just copy paste down)

=MID(D2, 45, LEN(D2))

Then, use the results as you wish - probably best as "copy value" or such

Cheers

 

[Afarag]

@Somendra Misra & @Steve May

can i depend on the 2nd table in exporting the name only, as at my data source the word of "Chat Support" isn't followed always by a Name.

check the full data

thanks a lot,

 

[Steve May]

I think it would be useful to know what you will actually do with the extracted data… for example, if you are looking to count how many times an agent has interacted, then this would be a COUNTIF function,…

 

[Afarag]

Hi steve,

i need to know the creator of this ticket, and this data is exported with the shown form, the employee name is filled within a "large text" when exporting the employee name can match some results else in my report

 

[Steve May]

OK, so where in your data set is that information contained? Is it in row 4 where it states "Chat queued to Live Chat Support NAME" ?

If the info is only ever stated once in the session, then a search, then lookup function would probably do the trick…