Extracting data from edit box



I have the following data in an edit box in the format :

"Co-Operative Bank Plc;@75;Burleigh Street;CAMBRIDGE;CB1 1DF

I need to put into a memo field as :

Co-Operative Bank Plc
75 Burleigh Street
CAMBRIDGE
CB1 1DF

ie strip out " from "Co-Operative Bank Plc


;@ from ;@75
; from Burleigh Street then add 75

; from CAMBRIDGE

; from CB1 1DF

Also once in a memo how do I read the last item in the list.


Cheers

SteveW



.