Scenario "Separating Full Name in Column A into three columns, one for First Name, Middle Name, and Last Name" ... E.g.: Column A: "FirstName MiddleName LastName"; Result Column B: "FirstName"; Column C: "MiddleName" and Column D: "LastName".
How can on do this?
You could just use excels built in function of Text to Columns its found under DATA on the menu bar, select column A, then DATA, TEXT TO COLUMNS,the list is delimited and you will get given the option when clicking next to choose the delimiter (which is space)
Not all forums are the same - seek and you shall find
Questions:
Are there always 1 middle name and can they have 2 last names?
Does the name sometimes include Mr, Mrs etc?
//Ola
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks