Question

A B C D E F G н Find First Name & Middle Initial Full Name Last Name #NAME? #VALUE! 1 Name 2 GAINES THOMAS M. 3 Stone Jerome 4 Cannon Simone Z 5 Campbell Reece H. 6 Chase Stafford 7 Mcclain Jack 8 JONES BOBBYJ. Clean GAINES THOMAS M. Stone Jerome Cannon Simone Z Campbell Reece H. Chase Stafford Mcclain Jack JONES BOBBYJ. Proper Gaines Thomas M. Stone Jerome Cannon Simone Z Campbell Reece H. Chase Stafford Mcclain Jack Jones Bobby). Trim Gaines Thomas M. Stone Jerome Cannon Simone Z Campbell Reece H. Chase Stafford Mcclain Jack Jones Bobby). 9 Davis Tanner 10 Murray Colt Q. 11 GIFFORD MARJORIE 12 HANKINS ELIZA S. 13 Branch Anthony 14 Bray Brian 15 JOYCE DAVID J. 16 KRAUS CAROLT. 17 LAMB SAMANTHA 18 Kirk Jocelyn B. 19 LEWIS PATRICK 20 Gentry David 21 PREWITT HANNAH E. 22 RANGELL JOHN W. 23 RUSSO ROBERT 24 TATE ANDREA M. 25 THOMPSON SHARON 26 WOODFORD VERA T. 27 Davis Tanner Murray Colt Q. GIFFORD MARJORIE HANKINS ELIZA S. Branch Anthony Bray Brian JOYCE DAVID J. KRAUS CAROLT. LAMB SAMANTHA Kirk Jocelyn B. LEWIS PATRICK Gentry David PREWITT HANNAH E. RANGELL JOHN W. RUSSO ROBERT TATE ANDREA M. THOMPSON SHARON WOODFORD VERA T. Davis Tanner Murray Colt Q. Gifford Marjorie Hankins Eliza S. Branch Anthony Bray Brian Joyce David J. Kraus Carol T. Lamb Samantha Kirk Jocelyn B. Lewis Patrick Gentry David Prewitt Hannah E. Rangell John W. Russo Robert Tate Andrea M. Thompson Sharon Woodford Vera T. Davis Tanner Murray Colt Q. Gifford Marjorie Hankins Eliza S. Branch Anthony Bray Brian Joyce David J. Kraus Carol T. Lamb Samantha Kirk Jocelyn B. Lewis Patrick Gentry David Prewitt Hannah E. Rangell John W. Russo Robert Tate Andrea M. Thompson Sharon Woodford Vera T. 28

Answer 1

8. Write this formula in E2 and drag to copy down the rows:   =FIND(" ",D2,1)

9. Write this formula in F2 and drag to copy down the rows:   =LEFT(D2,E2)

10. Write this formula in G2 and drag to copy down the rows:   =RIGHT(D2,LEN(D2)-E2)

11. Write this formula in H2 and drag to copy down the rows:   =G2&" "&F2

Note that formula in E3 will return #VALUE! error, because there is no space between the last and first name

The formulated sheet is following:

- A B 1 Name Clean 2 GAINES THOMAS M. GAINES THOMAS M. 3 StoneJerome StoneJerome 4 Cannon Simone Z Cannon Simone Z 5 Campbell Reece H. Campbell Reece H. 6 D E F G Н. Proper Trim Find Last Name FirstName & Middle Initial Full Name Gaines Thomas M. Gaines Thomas M. 7 Gaines Thomas M. Thomas M. Gaines StoneJerome StoneJerome #VALUE! #VALUE! #VALUE! #VALUE! Cannon Simone Z Cannon Simone Z 7 Cannon Simone Z Simone Z Cannon Campbell Reece H. Campbell Reece H. 9 Campbell Reece H. Reece H. Campbell 7 8 9 10 11 12 13

FORMULA VIEW:

B A 1 Name 2 GAINES THOMAS M. 3 StoneJerome 4 Cannon Simone Z 5 Campbell Reece H. 6 Clean GAINES THOMAS M. StoneJerome Cannon Simone Z Campbell Reece H. C D E F G H Proper Trim Find Last Name FirstName & Middle Initial Full Name Gaines Thomas M. Gaines Thomas M. =FIND("",D2,1) =LEFT(D2,E2) =RIGHT(D2,LEN(D2)-E2) =G2&" "&F2 StoneJerome StoneJerome =FIND("",D3,1) =LEFT(D3,E3) =RIGHT(D3,LEN(D3)-E3) =G3&" "&F3 Cannon Simone Z Cannon Simone Z =FIND("",D4,1) =LEFT(D4,E4) =RIGHT(D4,LEN(D4)-E4) =G4&" "&F4 Campbell Reece H. Campbell Reece H. =FIND("",D5,1) =LEFT(D5,E5) =RIGHT(D5,LEN(D5)-E5) =G5&" "&F5 7