Sum them? Or concatenate them? Or something else? If sum them then it's simply:<ul>[*]=sum(A1:A6970)[/list](This assumes your data are in column A, as you did not specify which column they data are in.)
The range specified (1:6970) is not a valid range, unless you're referring to the entire rows from row 1 to row 6970, which houses (in versions 97-2003) 256 columns for each row, equalling 6970 * 256 = 1784320 cells total.
Can you explain more about what you are wanting to do? Maybe tell us any criteria or what the intended purpose of this is?
All cells contain email addresses. I use lotus notes and for some reason lotus notes will not allow me to send out the email if the data is line by line (see fig 1). The only way it seems to work is if the emails are right after each other like fig 2. That is why I want to combine all data into one cell because when I copy data from cell A1:A6970 they paste like fig 1. So I am hoping to combine the data in one cell so that when I paste, the data will appear like fig 2 below. Thanks
I don't have lotus notes and don't know if there is a limit in the To box, but you could loop through the cells, appending the To box value each time. I would be careful if you set it to a variable, as they have limits too.