populate concatenate field

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
 
C

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 (e-mail address removed)
 
I

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display specific values in Dropdown2 based on selection in Dropdow 4
VBA HELP: Display values in Dropdown2 based on Dropdown2 selection 2
looping colums and rows 11
to give numbers to rows as per your wish 2
sorting by last char 3
Macro to pull data with criterea for placement on a new sheet 7
how can i count multiple variables in multiple columns? 1
IF/THEN/ELSE for sequential numbers 4

Top