Document Sample

```					    Spreadsheet Tutorial #6
TEXT 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.

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!)
TEXT me

Caller Name             UPPER&LOWER CASE MIDDLE LENGTH OF NAME   SURNAME
MINOGUE,KYLIE
COWELL,SIMON
GERVAIS,RICKY
PAGE, JIMMY
PEGG,SIMON
BLAIR,TONY
ZETA-JONES, CATHERINE
DEPP,JOHNNY
ROSS,JONATHAN
MARTIN,CHRIS
KNIGHTLEY,KEIRA
FIRST NAME   FULL NAME

```
DOCUMENT INFO
Shared By:
Categories:
Stats:
 views: 4 posted: 11/14/2010 language: English pages: 218