populate concatenate field

  • Thread starter Thread starter igor
  • Start date Start date
I

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
 
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 (e-mail address removed)
 
unfortunatelly, that does not help much as i have 5000
rows in the first column and only 5 rows in the second.

please help
 
Back
Top