I wonder whether the following is feasible with a formula:
I would like to draw the WashingCode Descriptions for different items and enter them in the Column that has got the Description_Formula Header.
The code descriptions are to be separated by a manual line break.
Is this feasible with a formula or do I need VBA programming?
I have attached a similar sample table for your convenience.
Help is very much appreciated. Thank you very much in advance.
ItemCode WashingCode_1 WashingCode_2 WashingCode_3 Description_Formula
Z1 101 102 103 Sterile
Z2 102 104 105 Manual Washing
On the Second Worksheet
(named WashingCodes) the WashingCodes are listed in a table along with their description
102 Manual Washing
103 No Rubbing
104 Dry Cleaning
105 Mild Detergents
Format the cell with Wrap Text enabled.
CHAR(10) is the Ascii code for a Carriage Return.