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.
Code:
=IF(ISTEXT(A1),B1&B2,"")
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!