Enter a formula in cell H2 to display the length of the text in cell G2.
File
H2
1
AutoSave
Undo
Home
19
20
A
First
2 Dianne
3 Tanya
4 Peggy
Frank
6 Mamie
7 Barbara
8 Belinda
9 Brian
10 Ellen
11 Liz
12 Bootsie
13 Susan
14 Bill
21
Paste
15 Allison
16 Peggy
17 Dianne
18
Off
Insert
X Cut
[Copy
Clipboard
Format Painter
B
Last
Marr
Customer List-Saved -
Wright
Olson
Lewis
Wooster
Long
White
White
Reese
Ramey
Falls
Decker
Shand
Mann
Olson
Marr
Draw Page Layout
City
Гу
fx
C
Arial
BI
Davidsonville
Dover
Fairfax
Baltimore
Potomac
Arnold
Elkton
Elkton
Bowie
Alexandria
McLean
Winchester
Arlington
Fairfax
Fairfax
Davidsonville
D
State
MD
DE
VA
MD
MD
MD
MD
MD
MD
10
H
Font
VA
VA
VA
VA
VA
VA
MD
Y
Formulas
Α Α΄
ی ما
E
Visits Total Spent
15 $
95
F
35 $
6 $
20 $
10 $
17 $
22 $
9 $
20 $
15 S
10 S
10 $
20 $
35 $
15 $
Data
Review
Customer Id
2,300 MarrMDille
3,120 WrightDEover
7,200 OlsonVArfax
Alignment
1,100 LewisMDmore
2,840 WoosterMDomac
3,000 LongMDnold
3,460 WhiteMDkton
3,660 WhiteMDwson
3,960 ReeseMDowie
1,740 Ramey VAdria
2,740 Falls VALean
3,260 Decker VAster
4,540 ShandVAgton
4,620 Mann VArfax
View
7,200 OlsonMDwson
2,300 MarrVAling
Table Design
ab Wrap Text
Merge & Center.
H
ID Length
General
$-%9
Number
Search (Alt+Q)
5
Conditional Format Cell
Formatting as Table Styles -
Styles
M
Insert
N
MA
Delete For
Cells
O