Question
E mart Draw Page Layout Formulas Dela Review View Developer Calibri del AA General 6 NO :x-4 Cel m- ao 4 Separate first and
E mart Draw Page Layout Formulas Dela Review View Developer Calibri del AA General 6 NO :x-4 Cel m- ao 4 Separate first and last NAMES UST names into distinct columns Display the first 2 characters of the FIRST name Merge first name and last name, with Make names All a comma and space lowercase in between Display ALL names in the Proper Reformat as follows: Fint initial, followed by a period, followed by the proper version of the last name Email Address (ALL lower Case) Alternate email address FUNCTIONS UST Above is a list of names that need to be reformatted. To the right (blue box) is an assortment of text-manipulation functions you MUST use to mimic the appearance of the specimens (row 2). Try to figure out which functions from the functions list are needed to reformat the names, starting with Rena Berkowicz. HINT: Some functions may not be needed while some functions may be needed more than once. Functions can be combined (nested) if necessary Concatenate Proper Left Upper Substitute Right Lower Text to Columns
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started