I´m trying to work out the following problem.

I have a range of cells each containing a name. Based on a number that has to be entered manually I want excel to return the names concatenated in one cell. So for example:

Number of variable entered:

**5**

q9001 |

q9002 |

q9003 |

q9004 |

q9005 |

q9006 |

<tbody>

</tbody>

Should give me: "q9001 q9002 q9003 q9004 q9005"

I have been trying to work with formulas using IF and CONCAT functions. But so far I haven't figured out how to have excel return me the correct amount of variables for each separate number that can be entered seeing the number of variables entered can vary from 1 up to 50.

Hopefully somebody can point me in the right direction. Is this doable using only formulas or should I use VBA? If so, for what kind of macro function should I be searching for on the internet? I hope somebody can help me on my way and tell me where I should start searching.

Thanks in advance, all your help is appreciated.

(Using Excel 2010)