I'm using excel 2003.
In column a, b, and c, I have a series of words. How do I have column d be a summation of all the words. I don't want to merge the cells as I need the original data.
eg column a - this
column b - is
column c - a test today
output in column d would be
this is a test today
2007-08-02 10:55:54 · 9 answers · asked by Anonymous in Computers & Internet ➔ Software
=A1&" "&B1&" "&C1
Then use the fill handle and drag the formula down
2007-08-04 13:04:09 · answer #1 · answered by David M 6 · 0⤊ 0⤋
To clarify the previous posts.
The " " is a text string with a space character in between the quotes. This spaces the words correctly.
An alternative would be to include a space after the words in each cell, then the formula would be:
=concatenate(A1,B1,C1)
2007-08-02 11:23:50 · answer #2 · answered by vbmica 7 · 1⤊ 1⤋
You can still do it using formulas, to combine the cells with =A1 & B1 & C1 Copy the results, and on the new sheet, right click and Paste Special >> Values. If you still prefer VBA, I'll defer to Garbo, or any of the other VBA experts here.
2016-05-21 03:32:44 · answer #3 · answered by elnora 3 · 0⤊ 0⤋
You don't need this "CONCATENATE" function (This is the longest function ever in Excel)
You can easily paste this in Cell D1
=A1&" "&B1&" "&C1
Then copy and paste it to the cells below
Enjoy my profile, I am the VBAXLMan here
2007-08-02 20:25:05 · answer #4 · answered by Anonymous · 0⤊ 0⤋
type =CONCATENATE(A1,B1,C1) in D1
you can find any of these formulas if you click on the fx button where you type in the formula and it gives you different formulas to use.
use the dropdown list to select the category ex: numbers, text, financial, math &trig etc. and below is a box that asks you to select a function and below that box is a description of what the current highlighted function does!
good luck with what you're doing!
2007-08-02 11:54:00 · answer #5 · answered by Isabella Z 2 · 0⤊ 1⤋
use the concatenate function. Type the following line into column d
=concatenate(A1, " ", B1, " ", C1)
2007-08-02 11:04:54 · answer #6 · answered by Dave 2 · 1⤊ 1⤋
d1= concatenate(a1, " ", b1, " ", c1);
2007-08-02 11:01:52 · answer #7 · answered by GinsuMaster 3 · 1⤊ 1⤋
I'm working on it
2007-08-02 11:16:09 · answer #8 · answered by kamaole3 7 · 0⤊ 2⤋
=CONCATENATE(column a," ",column b," ", column c)
Ex.
=CONCATENATE(A1," ",B1," ",C1)
2007-08-02 11:08:59 · answer #9 · answered by Anonymous · 1⤊ 1⤋