combine text

Question

I want to enter data oin tweo columns, and then have the third column combine the entries in the first two columns for anew text entry. For example:Palette&nbsp; &nbsp; &nbsp;Batch&nbsp; &nbsp; &nbsp; &nbsp;SKUAutum&nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Autumn 2Winter&nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Winter 3Spring&nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Spring 3&nbsp;&nbsp;I enter select Autymn from a dropdown, then select 2 from a drop down. Autumn 2 appears as the SKU

leoperdia · Answer

Hi&nbsp;compuquak&nbsp; whatever is your input method in colume one and two, to get that you want in column three you can do following formula: =A2&amp;" "&amp;B2 I'm supposing&nbsp;Autum is in A2 and "2" is in B2.&nbsp;Referring drop down do you know how to do it? Let me know in any case&nbsp;Regardshttps://www.upwork.com/freelancers/~01cf0fc8446b00f44c&nbsp;&nbsp;&nbsp;

Forum Discussion

combine text

1 Reply

Resources