How Can create an absolute reference to multiple cells column and/or row at a singe go

Question

How Can I create an absolute reference to multiple cells column and row at a singe go

Problem

2 3 4

A 2A 3A 4A

B

C

D

E

Expected Solution

2 3 4

A 2A 3A 4A

B 2B 3B 4B

C 2C 3C 4C

D 2D 3D 4D

E 2E 3E 4E

Answer 1

If 2,3,4 is in range B1:D1 and A:E is in range A1:A5, then in cell B2, enter this formula

=A$1&$B1

I believe your formula to be corrected by interchanging $  and it should have been =$A1&B$1

May be if data is like this screen shot then, the formula in B2 would be    

=$A2&B$1           and then right/down.

Answer 2

After typing 2 3 4 in A1, use this in A2,

=LEFT(A$1,1)&CHAR(ROW(65:65))&" "&MID(A$1,3,1)&CHAR(ROW(65:65))&" "&RIGHT(A$1,1)&CHAR(ROW(65:65))

Then fill down an additional 25 rows.

Hyperlink	Description
LEFT function	Returns the leftmost characters from a text value
MID function	Returns a specific number of characters from a text string starting at the position you specify
RIGHT function	Returns the rightmost characters from a text value
CHAR function	Returns the character specified by the code number
ROW function	Returns the row number of a reference

Answer 3

It works Thank you

Answer 4

Hi,

Thank you for making that correction.

Answer 5

Hi,

If 2,3,4 is in range B1:D1 and A:E is in range A1:A5, then in cell B2, enter this formula

=A$1&$B1

Copy this down and to the right.