concatenate 2 column

[okl]

Hi,

i trying to merge column A1 (ABC) with column B1(XYZ), B2(LOL), B3(ROF) ..etc

with a simple =CONCATENATE(A1,"-",B1) , i can get "ABC-XYZ" , but when come to column B2 , i only can get "-LOL" , any solution ?

[DonkeyOte]

Using formulae is not that straightforward given variable number of terms between groups, however...

If we insert a new Row 1 such that A1 becomes A2 and row 1 is blank then you could do something like:

Please Login or Register  to view this content.

the above assumes that the two groups of "BBC" are be to concatenated separately - hence use of ROW to differentiate.

[okl]

this is what i got:

but trying to get as below instead:

[DonkeyOte]

Right, in which case things are far simpler.

Ignore the Row 1 point from before - that can be deleted - simply use:

E1: =LOOKUP(REPT("Z",255),$A$1:$A1)&"-"&$B1
copied down

[romperstomper]

If you don't have hyphens in your actual column A data, then this is straightforward - see attached.