3 replies
by l0g1c19 Accepted solution
by jdclyde Accepted solution
because as soon as you do, you lose the ability to work with whatever is the second set of data.
Best thing to do, copy the column, then delete out the first name from one, and delete out the last name from the other.
by cmlott Accepted solution
If the format you want changed is like:
Last Name, First Name
use Excel's TEXT class of functions.
Create a formula that locates the position of the comma (FIND or SEARCH), and then
Use the LEFT function to save everything before the comma as the Last Name in one column, and
ditto for the right part as First Name in another column.
You probably also need the LEN function to find out how many characters need to be extracted from the right side, since names do vary in length.
This discussion is closed to new replies.
Trending Software posts
Sort by Trending