Question: Create an Excel function that first checks the String Length [function: = len(i)] of the elements of a column array. Then checks the Charater Types

Create an Excel function that first checks the String Length [function: = len("i")] of the elements of a column array. Then checks the Charater Types of the column array (Letters, Numbers, Special Characters). Then copies the data and reformats the data into the column to the right based on the following criteria. String Length =8 1-CASE OLD ARRAY NEW ARRAY AA12345AA12345 String Length =9 3-CASES OLD ARRAY NEW ARRAY AA 12345AAA12345A AA12A45AA12A45 AAA12345 AA 12345 String Length =10 3-CASES OLD ARRAY NEW ARRAY AA123A45AA123A45 AA123A456AA12A456 AAA 123A45 AAA 123A45 String Length =11 2-CASES OLD ARRAY NEW ARRAY AA-123A4567 AA-123A-4567 AAA-123A456 AAA-123A-456

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Answer the question shown below. Notes for reference shown below. \fThe function displays the promptstring, waits for keyboard input, and then returns the value from the keyboard. For example, >>...

Testcase file with output 1 Overview Wordle is an online word game, where you guess words and the computer tells you how close the word is to the secret word you're trying to find. Like the old game...

answer the question clearly You are building a flight-control system for which a convincing safety case must be made. Would you assign the tasks of safety requirements engineering, test case...

c++ In Part A, you will expand your search module to sort an array of strings and search the sorted array more efficiently. By the end of Part A, your search module will have functions with the...

C++ programming 1 of 3 Lab 13 Work You always create a separate C++ file for each program you write in the lab. 1. Write a C++ program that does the following: a. Create a C++ file with the name...

Hi I need help with this project that I am doing. It has to be in C language and I don't what to do. This is for my Data Structure course. Please it has to be in Language of C. Programming Assignment...

Hello I need help with this project //Please note I cant use any global variables or std:: libraries //I've posted my code from my last project under the this project description if that helps for...

I need help with this project, I am posting my code below the description of the project, I need help writing it without global variables and without using std libraries. I'm also posting an issue I...

1411116 - Programming I Assignment #3 Due Date: November 30, 2016 Submission Instructions: Submit your assignment on the blackboard link, corresponding to your Section: Please follow the following...

the 4 cells pleass 6. Tables Question 1. Suppose you have 4 apples, 3 oranges, and 3 pineapples. (Perhaps you're using Python to solve a high school Algebra problem. ) Create a table that contains...

Answer the following questions (taken from NIEE Case Study). a). On Freds first day, Wally says Were fast at Phaust. How might engineering decisions be affected by a corporate culture that emphasizes...

During the development of a sampling plan for the determination of Cu in tree bark a standard reference material of homogenized pine needles was used to study the effects of sampling variance. a)...

Your cousin has invested $ 5 0 0 today in a savings account. The total value of money she will have in her savings account one year from now is called the _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _...

how to solve this 9. Lina Co. has Quick ratio of 3x, sales of $120,000, in addition it has current assets of $170,000 and current liabilities of $50,000. The inventory turnover ratio for the company...

Discuss the advantages and disadvantages of various ways of eliminating a labor surplus and avoiding a labor shortage. page 188

Identify the three theories of discrimination under Title VII of the Civil Rights Act and apply these theories to different discrimination situations. page 113

Describe the various recruitment policies that organizations adopt to make job vacancies more attractive. page 204