How to get a spreadsheet file from the get directory

Reference no: EM133699

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: EM133699

Questions Cloud

Will barkley company record a profit under term modification : Will the profit recorded by Barkley be equal to the loss recorded by American Bank under the debt restructuring? Will Barkley Company record a profit under the term modification mentioned above

Why is it important for a business to register for vat : Distinguish between exemption and zero-rating for VAT purposes

Estimated tax payments : Through the year, Designs, Inc. made estimated tax payments of $1,500 each quarter to the IRS.

What is the forecasted addition to retained earnings : What is the forecasted addition to retained earnings for 2010? A budget is a formal written statement of management's strategies for the future expressed in financial terms. Evaluate the forecasted inventory balance have to be to achieve a Turn..

How to get a spreadsheet file from the get directory : How to Get a spreadsheet file from the get directory

What is the amount of total income recognized : What is the amount of total income recognized in the 2014 income statement solely as a result of these bonds?

Dement publishing division : Dement Publishing Division and Revenue to be recognized

Determine actual warranty costs : Determine Actual warranty costs

Solve the mean and standard deviation equations : Solve the mean and standard deviation equations

User Account

All Pages