Adding text from three cells into a separate cell

**raurie** · 02-05-2012, 05:19 PM

Hi,

I wonder if it is possible to do the following:

1. I am using EXCEL to collate columns of data and then compose a combination of the data in a seaparate column.
2. I have rows of reference codes in column A and rows of another reference code in column B.
3. I would like to set up a new code in colummn C that will read as: BOC_"code from column A"_"Code from coumn B". BOC is the name of a group that will be represented in column C

CodeA CodeB Code BOC
2341 8745 BOC_2341_8745
3453 3478
2312 5646
5412 6756

How do I use a formula or macro to allow Column c to be filled in?

Thanks

Raurie