populate concatenate field

[igor]

Hi,

i have two columns that contain the following:
a 1
b 2
c 3
d
e
..
..
..
what i need to do is create third column that will look
like this
1a
2a
3a
1b
2b
3b
1c
2c
..
..
Please help

 

[Chip Pearson]

Igor,

Try something like the following in the third column:

=B1&A1


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com [email protected]

 

[igor]

unfortunatelly, that does not help much as i have 5000
rows in the first column and only 5 rows in the second.

please help