3 Methods to Split a Name into Three Text Parts

1. Data
2. Text to Columns
3. Delimiters
4. Space
5. Next
6. Completed

First part
=LEFT(A14,FIND(" ",A14)-1)

Second part
=MID(A14,FIND(" ",A14)+1,FIND(" ",A14,FIND(" ",A14)+1)-FIND(" ",A14))

Third part
=RIGHT(A14,LEN(A14)-FIND(" ",A14,FIND(" ",A14)+1))

Join the online learning group — over 100 tutorial videos available anytime:

Facebook Group\r\n\r\nThe online learning group is divided into multiple units, including:

1. 1. Excel functions and formulas

1. Excel general features
2. Pivot operations
3. Excel charts and graphics
4. Excel VBA
5. PPT shapes and drawing
6. Word document processing
7. One-minute tutorials
8. Other Office tutorials and resources...

Further divided into multiple topics:

1. VLOOKUP
2. Charts
3. Text functions
4. Conditional formatting
5. Array formulas
6. Text processing
7. Hide
8. Find and Replace
9. Sort and Filter
10. Numbered lists
11. Shapes
12. Consolidation
13. Error messages
14. Cell formatting
15. Text to Columns
16. Watermark
17. Input method
18. Proofing
19. Name Manager
20. Page numbers
21. Printing
22. External data
23. Table of Contents
24. Workshop
25. Sum functions
26. Date and Time
27. PivotTable
28. Images
29. Keyboard shortcuts
30. Merge Cells
31. Random
32. Logical functions
33. Macro functions
34. Data Validation
35. Worksheet
36. Program Settings
37. Tables
38. Lookup functions
39. Duplicates
40. PDF
41. Go To
42. Comments
43. Special cells
44. Copy & Paste
45. Lock
46. Dynamic Charts
47. Layout
48. Headers and Footers, etc.

---

Demo Video:

---

Application process:

1. Payment
2. We will send you the Facebook Group link.
3. Answer a few questions before joining
4. We'll complete it after verification.

---

Fees:

$399 $199 [Join now, save $200]