Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I merge five cells into one?
I have read the previous posts about merging cells, but I am lost. Is there
a formula to merge 5 cells, with a space between each that I can apply to the whole table? WHere do I put the forumla, etc. I apologize in advance, I am not very familar with excel. |
#2
|
|||
|
|||
=a1&" "&b1&" "&c1&" "&d1&" "&e1
Put it in the cell that should show the results of this "merge". (It's usually called concatenation.) If you have formated dates/numbers, you may want something like: =text(a1,"mm/dd/yyyy")&" "&text(b1,"$0.00")&.......etc Mary wrote: I have read the previous posts about merging cells, but I am lost. Is there a formula to merge 5 cells, with a space between each that I can apply to the whole table? WHere do I put the forumla, etc. I apologize in advance, I am not very familar with excel. -- Dave Peterson |
#3
|
|||
|
|||
Dave - I still can't figure it out - How can I see the results and how can I
apply it to the whole table (about 3000 rows) Thanks! "Dave Peterson" wrote: =a1&" "&b1&" "&c1&" "&d1&" "&e1 Put it in the cell that should show the results of this "merge". (It's usually called concatenation.) If you have formated dates/numbers, you may want something like: =text(a1,"mm/dd/yyyy")&" "&text(b1,"$0.00")&.......etc Mary wrote: I have read the previous posts about merging cells, but I am lost. Is there a formula to merge 5 cells, with a space between each that I can apply to the whole table? WHere do I put the forumla, etc. I apologize in advance, I am not very familar with excel. -- Dave Peterson |
#4
|
|||
|
|||
Mary
Assume you have data in columns A through E for 3000 rows. In A1..this, B1..is, C1..mytext, D1..to, E1..concatenate In F1 enter Dave's formula. You will see the concatenated value in F1 i.e. "this is mytext to concatenate" will appear in F1 Double-click on the small black lump at bottom right corner of F1 and this formula will be copied with incrementation down as far as you have data in column E. If data is in some other configuation, please post an example of some cell and range references. Gord Dibben Excel MVP On Tue, 3 May 2005 12:07:09 -0700, "Mary" wrote: Dave - I still can't figure it out - How can I see the results and how can I apply it to the whole table (about 3000 rows) Thanks! "Dave Peterson" wrote: =a1&" "&b1&" "&c1&" "&d1&" "&e1 Put it in the cell that should show the results of this "merge". (It's usually called concatenation.) If you have formated dates/numbers, you may want something like: =text(a1,"mm/dd/yyyy")&" "&text(b1,"$0.00")&.......etc Mary wrote: I have read the previous posts about merging cells, but I am lost. Is there a formula to merge 5 cells, with a space between each that I can apply to the whole table? WHere do I put the forumla, etc. I apologize in advance, I am not very familar with excel. -- Dave Peterson |
#5
|
|||
|
|||
Debra Dalgleish has instructions on how to use that small black lump (aka
autofill handle) at: http://www.contextures.com/xlDataEntry01.html#Mouse Gord Dibben wrote: Mary Assume you have data in columns A through E for 3000 rows. In A1..this, B1..is, C1..mytext, D1..to, E1..concatenate In F1 enter Dave's formula. You will see the concatenated value in F1 i.e. "this is mytext to concatenate" will appear in F1 Double-click on the small black lump at bottom right corner of F1 and this formula will be copied with incrementation down as far as you have data in column E. If data is in some other configuation, please post an example of some cell and range references. Gord Dibben Excel MVP On Tue, 3 May 2005 12:07:09 -0700, "Mary" wrote: Dave - I still can't figure it out - How can I see the results and how can I apply it to the whole table (about 3000 rows) Thanks! "Dave Peterson" wrote: =a1&" "&b1&" "&c1&" "&d1&" "&e1 Put it in the cell that should show the results of this "merge". (It's usually called concatenation.) If you have formated dates/numbers, you may want something like: =text(a1,"mm/dd/yyyy")&" "&text(b1,"$0.00")&.......etc Mary wrote: I have read the previous posts about merging cells, but I am lost. Is there a formula to merge 5 cells, with a space between each that I can apply to the whole table? WHere do I put the forumla, etc. I apologize in advance, I am not very familar with excel. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Row height is not adjusting after activating Merge Cells & Wrap Te | Excel Worksheet Functions | |||
How do I merge cells in Excel, like just 2 cells to make one big . | Excel Discussion (Misc queries) | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
How can I merge unlocked cells in a worksheet that has been protec | Excel Discussion (Misc queries) |