I have a form with three cells like A1 - Apple, A2 - Banana and A3 - Oranges and the column B is where user inputs there data as how many each fruits they want
If the user fills the form as Apple = 2 Banana = 0 and Oranges =3
I want the code to output it as: "I want 2 apples and 3 oranges." With my code, I am having issues in placing "And" if user doesn't want all of these three fruits.
my formula is: ="I want "&B1&" "&A1 &", "&B2&" "&A2&" and "&B3&" "&A3 and output is "I want 2 Apple, 0 Banana and 3 Oranges". I want to get rid of the cell which doesn't have any order or Value