Forum Discussion
Combined 2 excel data show in other way?
Anson_Ong Not sure I follow, but you are working in a so-called structured table. When you construct a formula and point at a cell in such a table you'll enter structured references. So, when you are in D7, start typing the = sign and the click on H7, Excel will enter @[COLOR], being the cell from the current row in the column named Color. When the column name contains spaces or special characters, the reference becomes a bit different, as you can see with [@[ITEM NO.]]. But the principle is the same.
Make sure that column called "SKU No" is formatted as General before you enter the formula in D7. Then it should work, though you may want to change it to:
=[@[ITEM NO.]]&@[COLOR] or =[@[ITEM NO.]]&" "&@[COLOR] if you want insert a space between the number and the color. Press enter and the formula should copy itself down the entire column.
Anson_Ong Not sure I follow, but you are working in a so-called structured table. When you construct a formula and point at a cell in such a table you'll enter structured references. So, when you are in D7, start typing the = sign and the click on H7, Excel will enter @[COLOR], being the cell from the current row in the column named Color. When the column name contains spaces or special characters, the reference becomes a bit different, as you can see with [@[ITEM NO.]]. But the principle is the same.
Make sure that column called "SKU No" is formatted as General before you enter the formula in D7. Then it should work, though you may want to change it to:
=[@[ITEM NO.]]&@[COLOR] or =[@[ITEM NO.]]&" "&@[COLOR] if you want insert a space between the number and the color. Press enter and the formula should copy itself down the entire column.
Thanks a lot for the prompted reply. Yes, your solution worked, just make sure it formatted to General, and it works. Thanks a lot.
