combine cells into one.

erodjob

Active Member
Joined
Feb 11, 2003
Messages
253
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

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
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.)
 
Upvote 0
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?
 
Upvote 0
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
 
Upvote 0
...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?
 
Upvote 0
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
 
Upvote 0
Upvote 0

Forum statistics

Threads
1,226,456
Messages
6,191,145
Members
453,643
Latest member
adamb83

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top