Eshe Swafford Concate and Parse

Eshe Swafford Concate and Parse - Enter your First and Last...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
fc00eacf12da077b8a975620d9eeea8e13a9337e.xls fc00eacf12da077b8a975620d9eeea8e13a9337e.xls Concatenate and Parse 1 Concatenate text labels to form a string Name: Widget Inc. City: Dallas Example: Widget Inc., Dallas, TX 25241 Concatenate the data in C4, C5, C5 and C7 State: TX Address: Widget Inc., Dallas, TX 25241 Zip: 25241 2 Parsing Names Full Name: First Name: George George W. Bush Last Name: Bush Extract the last name of Bush Use Right and Len and Search Functi Upper Case GEORGE W. BUSH Convert George W. Bush name in Cell B11 to Upper Case 3 Rounding Value: 25.87 Enter the formla to calculate an Value: 19.19 Result: 1742.54 Value: 17.56 divided by C18. Your answer should Value: 5 be rounded to 2 decimal places 3 Name Eshe Swafford Green 9999 Tuesday 3/18/08
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Enter your First and Last Name in Cell C21 SS # 999-99-9999 Result: Swafford 9999 Tuesday 5/07/09 Date 5/7/2009 the last name in Cell C21 with the last 4 digits of the social security number in C22 with the date in C23 HINT: The right function shoud be used to concatenate the last name and social security number. The text function should be used to format and add the date (Except it will be your last name (not mine) See me if you have any questions. to look like Cell E5 Extract the name George Use Both the Left & Search Function Create a password that combines Your answer should be exactly like Cell E21 A B C D E F G 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36...
View Full Document

Ask a homework question - tutors are online