Dragging Formulas

[Steve]

Example:

Sheet 1 has two columns:
1. First Name
2. Last Name

I would like to concatenate the two names in a second
worksheet and place them in rows. My problem is, when I
drag the formula over, it does not increment the row
numbers from the first sheet.

Any ideas where I can work around this or will I have to
continue editing my formulas manually?

Thanks!

Steve

 

[Frank Kabel]

Hi
use a formula like:
=A1 & " " & B1

 

[JulieD]

Hi Steve

use
=Sheet1!A1 & " " & Sheet1!B1
where Sheet1 is the name of your sheet (if you have a space in the sheet
name you need to surround the sheet name with ' ' in the formula)

and drag down, this will give you a list of the names down the rows.

Hope this helps
Cheers
JulieD

 

[Steve]

Thanks JulieD

The problem is that on the sheet which contains the
formulas, I would like to drag across rather than down.

Any ideas?

 

[Frank Kabel]

Hi Steve
could you post how your formulas should look like in the
first cell and in the cell right to the first cell

 

[Steve]

Hi Frank,

First Cell
=CONCATENATE('Sheet1'!$A1," ",'Sheet1'!$B1)

Cell to the right of the first cell
=CONCATENATE('Sheet1'!$A2," ",'Sheet1'!$B2)

Thanks!

Steve

 

[Frank Kabel]

Hi
use the following formula in your first cell:
=OFFSET('Sheet1'!$A$1,COLUMN(A:A)-1,0) & " " & OFFSET
('Sheet1'!$B$1,COLUMN(A:A)-1,0)

and copy this to the right

 

[Steve]

Thanks!

-----Original Message-----
Hi
use the following formula in your first cell:
=OFFSET('Sheet1'!$A$1,COLUMN(A:A)-1,0) & " " & OFFSET
('Sheet1'!$B$1,COLUMN(A:A)-1,0)

and copy this to the right


.