Extract...

[How_Do_I]

Hello all... Is there a way to do this please... I need to extract the topics from my data... So in cell B7 after the word "Agenda"... I'd want the text after "1." but before "2." in C7. Then agenda 2. in D7 etc across the row... I'm assuming numbers in Agenda 1 would mess everything up but I have 1000s of these so anything that helps speed things up would be appreciated…

Excel Workbook
	B	C	D
6		1	2
7	Record Type: Conclusion. Former Reference: WM (44) 51. Attendees: W Churchill; C Attlee; E Bevin; H Morrison; J Anderson; O Lyttelton; Woolton; S Bruce; F Khan Noon; L Amery; J Grigg; S Cripps; R Law; A Cadogan; C Portal; Jammu and Kashmir; Beaverbrook; A Alexander; A Sinclair; B Bracken; Cherwell; A Cunningham; A Brooke. Agenda: 1. His Highness the Maharaja of Kashmir and Sir Firoz Khan Noon; 2. Naval, Military and Air Operations - Air Operations - Home Theatre. 'Crossbow' Targets. Mediterranean - Naval Operations - India. Mediterranean - Military Operations - Russia. Burma. New Guinea; 3. Russia - Loan of British Warships; 4. Foreign Affairs - Greece - Italy - France - Egypt; 5. 'Overlord' Security - Censorship of Diplomatic Communications from this country.	His Highness the Maharaja of Kashmir and Sir Firoz Khan Noon	Naval, Military and Air Operations - Air Operations - Home Theatre. 'Crossbow' Targets. Mediterranean - Naval Operations - India. Mediterranean - Military Operations - Russia. Burma. New Guinea;
Sheet1

 

[How_Do_I]

Re: Post #16 try :-

=IF(ISNUMBER(FIND(COLUMNS($AA11:AA11)&".",$J11)),TRIM(MID(SUBSTITUTE(SUBSTITUTE(" "&$J11," "&COLUMNS($K11:K11)&".",REPT(" ",LEN($J11)))," "&COLUMNS($K11:K11)+1&".",REPT(" ",LEN($J11))),LEN($J11),LEN($J11))),"")

hth

I was looking through these posts and saw your reply... Thanks Mike... Quarterfinals mate, hope the English clubs avoid each other...