geofspa
New Member
- Joined
- Jan 7, 2012
- Messages
- 30
- Office Version
- 365
- Platform
- Windows
Hi
I need to compile a number of text cells together - the entries might be 3 or 4 items long - or may be up to 50+ .
I have enetered formula as below and this does the job, but looks nasty - the result is an ever increasing text line - with only the last line being relevant.
<tbody>
</tbody>
results in
<tbody>
</tbody>
I need to compile a number of text cells together - the entries might be 3 or 4 items long - or may be up to 50+ .
I have enetered formula as below and this does the job, but looks nasty - the result is an ever increasing text line - with only the last line being relevant.
32240 | =IF(A1="","",A1) | or |
31759 | =IF(A2="","",CONCATENATE(B1,$C$1,A2)) | |
31614 | =IF(A3="","",CONCATENATE(B2,$C$1,A3)) |
<tbody>
</tbody>
results in
<tbody> </tbody> | |||||||
<tbody> </tbody> |
<tbody>
</tbody>