Copying formulas to tables

I've following situation (a simplified example): I've information (text) in
A2:A10 and B1:G1. For each cell in the range B2:G10 I want to CONCATENATE the
text from the corresponding cell in A2:A10 with the text from B1:G1. For
example, D7=CONCATENATE(A7,D1). Is there any way to do this quickly without
having to introduce formulas manually either in the first column or in the
first row (my data has several thousands rows)?

Thanks,

Sokol

Enter the below formula in cell B2 and copy across and down as required

=$A2&B$1

If this post helps click Yes
---------------
Jacob Skaria


"Sokol" wrote:

> I've following situation (a simplified example): I've information (text) in
> A2:A10 and B1:G1. For each cell in the range B2:G10 I want to CONCATENATE the
> text from the corresponding cell in A2:A10 with the text from B1:G1. For
> example, D7=CONCATENATE(A7,D1). Is there any way to do this quickly without
> having to introduce formulas manually either in the first column or in the
> first row (my data has several thousands rows)?
>
> Thanks,
>
> Sokol