Free Text Functions Practice for Google Sheets

Question 1 of 3

Try it yourself

In F2, clean the name in A2: TRIM the spaces away, then PROPER the capitalization. Nest them, TRIM first.

A

B

C

D

E

F

G

H

I

J

1

2

3

4

5

6

Name

Email

Phone

Address

Company

Clean Name

SHERLOCK HOLMES

sherlock.holmes@bakermail.com

(555) 123-4567

221B Baker Street, Marylebone, London NW1 6XE

holmes and watson consulting

Question 2 of 3

Try it yourself

In I4, count the characters in the raw name in A2. It is longer than it looks: LEN counts the spaces you cannot see.

A

B

C

D

E

F

G

H

I

J

K

L

M

1

2

3

4

5

6

Name

Email

Phone

Address

Company

Clean Name

SHERLOCK HOLMES

sherlock.holmes@bakermail.com

(555) 123-4567

221B Baker Street, Marylebone, London NW1 6XE

holmes and watson consulting

Answer

Question 3 of 3

Try it yourself

In I4, clean the padded name in A2 with TRIM. TRIM removes the spaces at both ends AND collapses runs in the middle to one.

A

B

C

D

E

F

G

H

I

J

K

L

M

1

2

3

4

5

6

Name

Email

Phone

Address

Company

Clean Name

Irene Adler

i.adler@bakermail.com

555-234-5678

Briony Lodge, Serpentine Avenue, London NW8 3JR

Watson Medical Supplies

Answer

You just read about Text Functions. Now type one.