# combine cells into one.

#### erodjob

##### Active Member
I have cells 1:6970 with data in each cell. How can I combine all values in cells 1:6970 into cell B1?

I use excel 2003.

Thank you

### Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
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.)

Hi there,

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?

Sorry for the confusion.

I have data in each cell from A1:A6970. I would like to merge all that data into cell B1. Each cell contains about 15 characters each. Can that be accomplished using excel 2003?

Thank You

...I would like to merge all that data into cell B1. Each cell contains about 15 characters each...
-erodjob

• There is a limit to the number of characters that Excel will display. You can get ballpark around 10K to show as I recall.
• 104K characters in one cell??? Why would you want to do this in the first place? Maybe there is another way to get you to where you need to get? What's your destination?

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

Fig 1
hjh@aol.com,
kdjk@aol.com,
kjdh@aol.com,

Fig 2
hjh@aol.com,kdjk@aol.com,kjdh@aol.com

Are you doing this via VBA? Or manually?

Which ever way is easiest will work.

I need to send the email as one bulk email. I don't think this will work.

Replies
10
Views
180
Replies
7
Views
87
Replies
8
Views
248
Replies
8
Views
73
Replies
11
Views
138

1,203,605
Messages
6,056,270
Members
444,853
Latest member
sam69

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back