Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Splitting Inconsistent Full Names

Medium
SQL & Data ManipulationData WranglingExcelAsked 1 times

Problem

What Excel formulas or features would you use to split a column of full names into first, middle, and last names when the formatting is inconsistent?

You are practicing as a guest. Sign up free to get your answer graded with AI feedback. Your draft stays right here.

Sign up freeI have an account
Sign up to unlock solutions
6sense Research Analyst Interview Questions6sense Interview Questions
Next questions
ZulilyExcel Formulas for Unstandardized DataEasyHexaware TechnologiesNormalize Excel DatesEasySouth Carolina StaffingExcel Data Cleaning and ReconciliationEasy
0 / ~200 words