Hello all -

Please help armature excel newly bee! :roll:

Here is my input:

A (file name) B (desc)
------------------ ----------------------------------------------------------
1 ACCOUNTS This file stores the SAC flags per module/process. 2 2 the key to this file varies from
3 a module name, such as ELG, CLM, etc. or can be a
4
5
9
10
11 ACTIVESUB Store SUB data in adequate format for check


12 printing. Several claim may be grouped into one
13
14
15A_TRANS This file contains information which describes
the annuity transaction represented by the key.


A column holds the file name & B is file description. How do I merge the entire description into one line?

The following formula would work for the first two (the number of lines in description field is variable. The separation between the old & the new description line is blank).
So, on the output I should have

A B
----- ------
1ACCOUNTS This file.....
2ACTIVESUB Stores....
3A_TRANS This file .....

Really appreciate your help!