Page 1 of 1

This is an excel question: -Explanation I have 3 columns The 1st column contains rows with blank information. -Question

Posted: Fri Jul 08, 2022 7:27 am
by answerhappygod
This is an excel question:
-Explanation
I have 3 columns
The 1st column contains rows with blank information.
-Question
In the 4th column I'm doing 2 of the following:
1. write the first letter of column 2, write the first letter of column 3 and put a "." and write all of the letters with the rows that aren't missing information in column 1 alongside writing open at the end
2. With the rows missing information from column 1 I will do the following: Write first 2 letters of colum 3 put a "." then write all of colum 2 text and then write open at the end
Visual explanation: A B C 1Potato Magic Chegg2 Happy Excel3 Corn Fun Pizza
mp.cheggopen ha.excelopen ha is first 2 letters of happyfc.pizzaopen
They must all be in lower case
What is the formula?