Most valuable professional
  • Hot Topics

Excel Formula listing items from several columns in one column

Hi Mr Excel, In columns B, C, D & E I have titles with items. I need formula listing the titles (upper case letters) with different items (lower case letters) in column A as shown on the example below. The number of the items is variable linked to database. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

This question generated 20 answers. To proceed to the answers, click here.

This thread is current as of March 25, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel