merging into single column

**rossryan** · 09-25-2009, 03:15 AM

How do I execute this in excel? - I have value starting with the word “code” in different cell / column, how would I able to select all these values and transfer them into single column. Thanks.

**DonkeyOte** · 09-25-2009, 03:21 AM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

**rossryan** · 09-25-2009, 03:48 AM

Sorry - anyway i have attached the sample form

**DonkeyOte** · 09-25-2009, 03:50 AM

If the code is always the last text entry in the row then

S2: =LOOKUP(REPT("Z",255),A2:R2)
copied down

**rossryan** · 09-25-2009, 06:45 AM

Thanks that’s powerful. In your formula S2: =LOOKUP(REPT("Z",255),A2:R2) what does rept ,“z”, and 255 means? Thanks again.

**DonkeyOte** · 09-25-2009, 08:10 AM

For info. on REPT function see XL Help files - for more info. on "finding last values" be sure to check out Bob Phillips' white paper: http://www.xldynamic.com/source/xld.LastValue.html