Concananate Function for Multiple Rows

M

mardskee

Everyone,

I am looking to take text data from Column 1, Column 3, and add text after
these values for every row in my spreadsheet. Is there a universal equation
that I can use instead of having to insert values from each row individually
using the Concananate function???

Thanks for the response
 
H

Harlan Grove

mardskee wrote...
I am looking to take text data from Column 1, Column 3, and add text after
these values for every row in my spreadsheet. Is there a universal equation
that I can use instead of having to insert values from each row individually
using the Concananate function???
Click to expand...

Using just built-in worksheet functions, you need to have a separate
term for every row. If you're willing to use VBA to write user-defined
functions, you could try

http://groups-beta.google.com/group/microsoft.public.excel.worksheet.functions/msg/94456a9e326b19a6

(or http://makeashorterlink.com/?Y34926EBA).
 
B

Bucky

mardskee said:
I am looking to take text data from Column 1, Column 3, and add text after
these values for every row in my spreadsheet. Is there a universal equation
that I can use instead of having to insert values from each row individually
using the Concananate function???
Click to expand...

I don't think I understand your question. Can't you just create the
formula for the first row (=A1 & A2 & "mytext"), then do Fill > Down
for all the rows?
 
G

Gord Dibben

Your description is a little ambiguous to me.

Do you want column 1 and column 3 concatenated and text added to that?

Or do you want column 1 and column 3 separately concatenated with text?

For first scenario enter =A1 & C1 & "text" in D1

Drag/copy down as far as you need.

Second scenario enter =A1 and "text" in D1 and drag/copy down.

Enter =C1 and "text" in E1 and drag/copy down.

To enter spaces between you would add them like =A1 & " " & C1 & " text"


Gord Dibben Excel MVP
 
Top