How to extract the name and address from mailing list cell in Calc

[Ram.BM]

I have data in libroffice calc like below

"V K RAJU
E -45  COLLEGE LANE
BENGALI MARKET
XYZ  -110001"
"B  PAVAN KUMAR SARMA
D.No: 4318/3,Ansari Road, Dariya Gunj,
XYZ - 110 002."

like upto 3500 records are there in that file. In that file how to extract the mailing list please tell me as early as possible

In that data mailing list means what i want to extract(either name or Address)

[oweng]

If the first line is always the name (and only the name), this will obtain the name:

=TRIM(LEFT(A1;SEARCH(".\n";A1;1)))

The remaining lines of content (address) can be obtained using:

=REPLACE(TRIM(MID(A1;SEARCH("\n[.]*";A1;1);LEN(A1)-SEARCH("\n";A1;1)));1;1;"")

Example here.

[Ram.BM]

it is not work well because in libreoffice there is no " so please modify your answer

[oweng]

@Ram.BM, I left out a bracket in the address formula. Now corrected and example attached.

[Ram.BM]

Thanq it works now exactly thanq