Spreadsheet Tutorial #6
Before You Start, Click Here To Read Me!
If you finish easily, Click Here To Read Me!
MAKE SURE YOU HAVE LOOKED UP HOW TO USE TEXT FUNCTIONS BEFORE YOU TRY THIS!
1 Use the function PROPER in Column C, to convert the name to the right mix of upper and lower case letters
2 To begin separating first name from surname, you need to find the middle of each name. In Column D, Use the FIND function to loc
3 Once you have found the , character, createa formula in Column E using the LEN function to tell you how many characters are in eac
4 In Column F, work out the surname by using the LEFT function, with the value you found in Column D
5 In Column G work out the first name by using the RIGHT function (you will need to take away the the value in Column D from the valu
6 Join the two names together, first name first and with a space in the middle, by using =G5&" "&F5
7 Check your work - then SAVE it.
8 Set the PRINT AREA so that you select the cells containing data
9 Check Print Preview to make sure your sheet fits onto 1 page.
If it doesn't, use Page Setup and Scaling to adjust the printed size of the sheet.
10 Print your work
YOU TRY THIS!
er case letters
olumn D, Use the FIND function to locate the , character in each name
ell you how many characters are in each name
he the value in Column D from the value in Column E in this formula!)
Caller Name UPPER&LOWER CASE MIDDLE LENGTH OF NAME SURNAME
FIRST NAME FULL NAME