How to add ";" at the end of every sentence?

[elbrujo]

Hi there,

I have a format like this:

KW - Some-text with
Maybe
Multiple words
LA - English
...etc...
KW - Some text
With Maybe
Words
LA - Spanish
...etc...
KW - Text with
Maybe Multiple
words
LA - English
...etc...
KW - Some
Text
With
Maybe
Multiple
words
LA - Portuguese
...etc...

As you can see the KW - is followed by certain sentences, the first one is right after the KW - and the one per line, they end when LA - begins

I need to add a ; semi-colon at the end of each sentence under KW - how could I achieve this?
In the ...etc... are many other data that should be untouched.

Like this:

KW - Text with;
Maybe Multiple;
words;
LA - English
...etc...
KW - Some;
Text;
With;
Maybe;
Multiple;
words;
LA - Portuguese
...etc...

Thank you very much for your time,
Regards.

[Sam Capricci]

how can someone tell what "constitutes" a sentence? Is phrase as shown in your post a single row?

[Sam Capricci]

since you haven't answered, I'll make an assumption and give you this simple answer.
if each of these…
KW - Some-text with
Maybe
Multiple words
LA - English
is represented by a row, then use this in the cell next to it…
=right(A1,99)&";"
assuming your data begins in column A cell 1.

[elbrujo]

Sorry for the delay. Indeed it is one per row!

Thank you very much!

[FDibbins]

How about just...
=A1&";"

[Sam Capricci]

Ford, much better and shorter. duh - why didn't I think of that one?

[FDibbins]

haha been there, done that

[elbrujo]

Hi there!,

Sorry to revive this thread but, how can I achieve this but only for records in KW?

Imagine the result list goes like this:

...
...
..
TY - JOUR
AN - WOS:000207966700012
DA - Jul-Sep
J2 - Acta Bioquim. Clin. Latinoam.
KW - CARDIAC TROPONIN-I;
ACUTE MYOCARDIAL-INFARCTION;
BRAIN NATRIURETIC;
PEPTIDE;
ARTERY-BYPASS-SURGERY;
ST-SEGMENT-ELEVATION;
CREATINE-KINASE-MB;
DEPARTMENT PATIENT SATISFACTION;
ACUTE;
PULMONARY-EMBOLISM;
CRITICALLY-ILL PATIENTS;
STAGE RENAL-DISEASE
LA - Spanish
M1 - 3
M3 - Article
N1 - ISI Document Delivery No.: V17WG
Times Cited: 0
Cited Reference Count: 218
Cited References:
....
...
...
..

Adding a ";" at the end of them, just them, excepting the very last one (as you can see its STAGE RENAL-DISEASE in this case)... I'd certainly need an automatic way since there are more than a million records :'(

The list I have doesn't have them with the ";" at the end... That's what I need, but exclusively for those within category KW excepting the last one of such category

It's always from KW to LA, expecting/skipping the last KW item...