If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I merge two cells without deleting data from the cell?
I'm highlighting two cells in the same row, hitting format cells, alignment,
merge cells and I'm getting the error message, "The selection contains multiple data values. Merging into one cell will keep the upper-left most data only." I want to be able to make the two seperate cells one without deleting anything and without having to cut and paste. |
#2
|
|||
|
|||
You can't, you can concatenate 2 cells into one by using a formula and
ampersand =A1&" "&B1 however stay away from merging cells, always cause more problems than what it's worth and layout wise you can get very close without using it. I have never seen a power user using merging Regards, Peo Sjoblom "Batmans_Wife" wrote: I'm highlighting two cells in the same row, hitting format cells, alignment, merge cells and I'm getting the error message, "The selection contains multiple data values. Merging into one cell will keep the upper-left most data only." I want to be able to make the two seperate cells one without deleting anything and without having to cut and paste. |
#3
|
|||
|
|||
Thank you so much for sending me this formula. It worked perfectly and did
exactly what I needed. I really appreciate your quick, helpful response. Sincerely, Michelle "Peo Sjoblom" wrote: You can't, you can concatenate 2 cells into one by using a formula and ampersand =A1&" "&B1 however stay away from merging cells, always cause more problems than what it's worth and layout wise you can get very close without using it. I have never seen a power user using merging Regards, Peo Sjoblom "Batmans_Wife" wrote: I'm highlighting two cells in the same row, hitting format cells, alignment, merge cells and I'm getting the error message, "The selection contains multiple data values. Merging into one cell will keep the upper-left most data only." I want to be able to make the two seperate cells one without deleting anything and without having to cut and paste. |
#4
|
|||
|
|||
To concatenate in place, you can use a macro like the one found he
http://www.mcgimpsey.com/excel/mergedata.html In article , Batmans_Wife wrote: I'm highlighting two cells in the same row, hitting format cells, alignment, merge cells and I'm getting the error message, "The selection contains multiple data values. Merging into one cell will keep the upper-left most data only." I want to be able to make the two seperate cells one without deleting anything and without having to cut and paste. |
#5
|
|||
|
|||
Thanks for sending the link to your page with the macros and instructions.
It's very detailed and thorough. Although I was able to figure it out with the formula that Peo posted earlier, I appreciate your further information and will keep it handy for future use. Sincerely, Michelle "JE McGimpsey" wrote: To concatenate in place, you can use a macro like the one found he http://www.mcgimpsey.com/excel/mergedata.html In article , Batmans_Wife wrote: I'm highlighting two cells in the same row, hitting format cells, alignment, merge cells and I'm getting the error message, "The selection contains multiple data values. Merging into one cell will keep the upper-left most data only." I want to be able to make the two seperate cells one without deleting anything and without having to cut and paste. |
#6
|
|||
|
|||
How do I merge two cells without deleting data from the cell?
Hi there
But I don't want formulas on the page.. As Well I am merging cell c and d and want the info to stay in d I will end up copying and pasting to another program Thanks Sandra "Batmans_Wife" wrote: Thank you so much for sending me this formula. It worked perfectly and did exactly what I needed. I really appreciate your quick, helpful response. Sincerely, Michelle "Peo Sjoblom" wrote: You can't, you can concatenate 2 cells into one by using a formula and ampersand =A1&" "&B1 however stay away from merging cells, always cause more problems than what it's worth and layout wise you can get very close without using it. I have never seen a power user using merging Regards, Peo Sjoblom "Batmans_Wife" wrote: I'm highlighting two cells in the same row, hitting format cells, alignment, merge cells and I'm getting the error message, "The selection contains multiple data values. Merging into one cell will keep the upper-left most data only." I want to be able to make the two seperate cells one without deleting anything and without having to cut and paste. |
#7
|
|||
|
|||
How do I merge two cells without deleting data from the cell?
I think I'd insert a new column E and put the formula there.
You could copy that range to the other program. Or you could convert that new column E to values and delete columns C (or just column D???). xjaysfan wrote: Hi there But I don't want formulas on the page.. As Well I am merging cell c and d and want the info to stay in d I will end up copying and pasting to another program Thanks Sandra "Batmans_Wife" wrote: Thank you so much for sending me this formula. It worked perfectly and did exactly what I needed. I really appreciate your quick, helpful response. Sincerely, Michelle "Peo Sjoblom" wrote: You can't, you can concatenate 2 cells into one by using a formula and ampersand =A1&" "&B1 however stay away from merging cells, always cause more problems than what it's worth and layout wise you can get very close without using it. I have never seen a power user using merging Regards, Peo Sjoblom "Batmans_Wife" wrote: I'm highlighting two cells in the same row, hitting format cells, alignment, merge cells and I'm getting the error message, "The selection contains multiple data values. Merging into one cell will keep the upper-left most data only." I want to be able to make the two seperate cells one without deleting anything and without having to cut and paste. -- Dave Peterson |
#8
|
|||
|
|||
How do I merge two cells without deleting data from the cell?
The answer to my prayers! How do you convert the column into values?
"Dave Peterson" wrote: I think I'd insert a new column E and put the formula there. You could copy that range to the other program. Or you could convert that new column E to values and delete columns C (or just column D???). xjaysfan wrote: Hi there But I don't want formulas on the page.. As Well I am merging cell c and d and want the info to stay in d I will end up copying and pasting to another program Thanks Sandra "Batmans_Wife" wrote: Thank you so much for sending me this formula. It worked perfectly and did exactly what I needed. I really appreciate your quick, helpful response. Sincerely, Michelle "Peo Sjoblom" wrote: You can't, you can concatenate 2 cells into one by using a formula and ampersand =A1&" "&B1 however stay away from merging cells, always cause more problems than what it's worth and layout wise you can get very close without using it. I have never seen a power user using merging Regards, Peo Sjoblom "Batmans_Wife" wrote: I'm highlighting two cells in the same row, hitting format cells, alignment, merge cells and I'm getting the error message, "The selection contains multiple data values. Merging into one cell will keep the upper-left most data only." I want to be able to make the two seperate cells one without deleting anything and without having to cut and paste. -- Dave Peterson |
#9
|
|||
|
|||
How do I merge two cells without deleting data from the cell?
Select the range to convert to values
Edit|Copy Edit|Paste special|Values Angie wrote: The answer to my prayers! How do you convert the column into values? "Dave Peterson" wrote: I think I'd insert a new column E and put the formula there. You could copy that range to the other program. Or you could convert that new column E to values and delete columns C (or just column D???). xjaysfan wrote: Hi there But I don't want formulas on the page.. As Well I am merging cell c and d and want the info to stay in d I will end up copying and pasting to another program Thanks Sandra "Batmans_Wife" wrote: Thank you so much for sending me this formula. It worked perfectly and did exactly what I needed. I really appreciate your quick, helpful response. Sincerely, Michelle "Peo Sjoblom" wrote: You can't, you can concatenate 2 cells into one by using a formula and ampersand =A1&" "&B1 however stay away from merging cells, always cause more problems than what it's worth and layout wise you can get very close without using it. I have never seen a power user using merging Regards, Peo Sjoblom "Batmans_Wife" wrote: I'm highlighting two cells in the same row, hitting format cells, alignment, merge cells and I'm getting the error message, "The selection contains multiple data values. Merging into one cell will keep the upper-left most data only." I want to be able to make the two seperate cells one without deleting anything and without having to cut and paste. -- Dave Peterson -- Dave Peterson |
#10
|
|||
|
|||
How do I merge two cells without deleting data from the cell?
See answer at your other post.
Gord On Mon, 28 Apr 2008 05:52:01 -0700, Angie wrote: The answer to my prayers! How do you convert the column into values? "Dave Peterson" wrote: I think I'd insert a new column E and put the formula there. You could copy that range to the other program. Or you could convert that new column E to values and delete columns C (or just column D???). xjaysfan wrote: Hi there But I don't want formulas on the page.. As Well I am merging cell c and d and want the info to stay in d I will end up copying and pasting to another program Thanks Sandra "Batmans_Wife" wrote: Thank you so much for sending me this formula. It worked perfectly and did exactly what I needed. I really appreciate your quick, helpful response. Sincerely, Michelle "Peo Sjoblom" wrote: You can't, you can concatenate 2 cells into one by using a formula and ampersand =A1&" "&B1 however stay away from merging cells, always cause more problems than what it's worth and layout wise you can get very close without using it. I have never seen a power user using merging Regards, Peo Sjoblom "Batmans_Wife" wrote: I'm highlighting two cells in the same row, hitting format cells, alignment, merge cells and I'm getting the error message, "The selection contains multiple data values. Merging into one cell will keep the upper-left most data only." I want to be able to make the two seperate cells one without deleting anything and without having to cut and paste. -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
multiple docs, one data source | kp | Mailmerge | 12 | January 31st, 2005 04:41 PM |
Pulling data from 1 sheet to another | Dave1155 | Worksheet Functions | 1 | January 12th, 2005 05:55 PM |
How do I get 3 series in sync with the x-axis? | zizbird | Charts and Charting | 10 | October 25th, 2004 01:23 PM |
Is this possible with Excel Chart? | q582gmzhi | Charts and Charting | 1 | September 8th, 2004 03:33 AM |
How to run word and pass a mail merge values and fax it to the recipient | Belinda | Mailmerge | 2 | June 13th, 2004 12:49 AM |