Table of Contents
🔹 Split Names Without Space in Excel Using Flash Fill
📌 Example Data:
| Full Name | Separated Name |
|---|---|
| AaravSharma | ? |
| VikramSingh | ? |
| RohanPatel | ? |
Steps to Separate Name & Surname in Next Row
1️⃣ In the next row, manually type the separated name with a space:
- Example: Aarav Sharma
2️⃣ Press Enter and go to the next cell.
3️⃣ Press Ctrl + E (Flash Fill).
✅ Excel will detect the pattern and instantly separate all names! 🚀
