Excel formula

[hyruleramone]

Hello,

Id like to know if there's a way in where I can extract the word [Resolution] from the following structure:

2014-07-08 05:01:20 - MICHAEL, JONES (Working area)
[Resolution]
User had an application that was removed . Problem has been solved.


I have 3011 rows with the same structure. Any help would be greatly appreciated.

Thanks.

 

[Br0ck]

With your data in A1...

=RIGHT(A1,12)

 

[hyruleramone]

With your data in A1...

=RIGHT(A1,12)

Thanks for replying.

how can I just get the word [Resolution] in a more precise way?

Thanks.

 

[Daveydoodles]

Is the word you need always in square brackets?

=MID(A1,FIND("[",A1),FIND("]",A1)-FIND("[",A1)+1)

 

[hyruleramone]

Is the word you need always in square brackets?

=MID(A1,FIND("[",A1),FIND("]",A1)-FIND("[",A1)+1)

Yeah, it is always between square brackets.

 

[arthurbr]

Cross post Excel formula

 

[hyruleramone]

Yeah, it is always between square brackets.

now another question:

within a text how can I get/extract the word "files to collect" or "files collection". I want to tell excel, if with this text you find "files to collect" or "files collections" please take it out.

Is that possible?