Retrieve particular text from a line

[nur2544]

Dear all, I want to retrieve particular text from a line , here is an example

Please Login or Register  to view this content.

I want to get like below

Please Login or Register  to view this content.

[José Augusto]

Does your text have this regularity?

[AlKey]

Enter in B1 and copy down

Please Login or Register  to view this content.

v	A	B
1	Share Holding Percentage [as on Jun 30, 2016 (year ended)]	Jun 30, 2016
2	Share Holding Percentage [as on Sep 30, 2017]	Sep 30, 2017
3	Share Holding Percentage [as on Oct 31, 2017]	Oct 31, 2017

[nur2544]

Hi AlKey, I appreciated it, It works perfectly , Thanks for helping me.

[nur2544]

Hi José Augusto, Yes you are right, only month name, date & year will be changed, rest of text are same pattern.