| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
populate concatenate field
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
populate concatenate field
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 "igor" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
populate concatenate field
unfortunatelly, that does not help much as i have 5000
rows in the first column and only 5 rows in the second. please help -----Original Message----- 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 "igor" wrote in message ... 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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to CONCATENATE two dates field together | Excel Worksheet Functions | |||
| How to accept input and then populate/concatenate this with other | New Users to Excel | |||
| Populate field automatically | Excel Discussion (Misc queries) | |||
| How to Join/concatenate a date field with a time field in Excel? | Excel Discussion (Misc queries) | |||
| Populate a field with just workdays | Excel Worksheet Functions | |||
Hybrid Mode
