Questionget a spreadsheet file hw9 from the get

Assignment Help Physics

Reference no: EM13349748

Question

Get a spreadsheet file HW9 from the get directory.

This file has 2 worksheets, the first is titled names and the second is titled words.

On a first worksheet is a list of names. They are given as last name, comma, and first name.

The problem is data is messed up. Some of names are in upper case, some in lower case, some a mix of both. There are also many extra spaces in data.

Your task is to generate three new columns: Last name, First name, Normal Name. In the Last name column remove the last name from column A and put it into this column, in First name column take the first names from column A and put them into this column. In Normal name column put the names back together but as first name space last name.

In adding, remove all the extra spaces and fix the names so only the first letter in each name is capitalized. On worksheet two (Words). I want you to count the number of words in the statement.

Reference no: EM13349748

Questions Cloud

Question on december 31 2012 the american bank enters into : question on december 31 2012 the american bank enters into a debt reformation agreement with barkley company which is

Question 1a you work in the tax department in a firm of : question 1a you work in the tax department in a firm of accountants. you have received a few queries from clients of

Question general company informationmargaret brown and joel : question general company informationmargaret brown and joel lee each own 50 percent of designs inc. with no other class

Question 1a budget is a formal written statement of : question 1.a budget is a formal written statement of managements strategies for the future expressed in financial

Questionget a spreadsheet file hw9 from the get : questionget a spreadsheet file hw9 from the get directory.this file has 2 worksheets the first is titled names and the

Question 1 on 1st january 2012 morlock associates purchased : question 1. on 1st january 2012 morlock associates purchased 5-year 5 percent bonds having maturity a value of 350000.

Questiondement publishing divisionthe dement publishing : questiondement publishing divisionthe dement publishing division sells large volumes of novels to a few book

Question ankiel securities divisionankiel securities : question ankiel securities divisionankiel securities division works throughout manufacturers agents in different cities

Questiondo problem at the end of the text booknbsp there : questiondo problem at the end of the text book.nbsp there are two sets of test scores titled part 1 and part 2.nbsp the

User Account

All Pages