Excel cell format?

@calvin222 (1607)
May 15, 2007 2:53am CST
Right now each cell is set up with "last name, first name". Is there an easy way to put each last name and first name in their own cell?
1 person likes this
2 responses
@rhinoboy (2129)
15 May 07
I don;t know of one, it's probably a lot of copying / pasting / deleting I'm afraid!
@calvin222 (1607)
• India
17 May 07
But i'm sure there is an eaiser way to do it.
• Vietnam
20 May 11
Hi, that's easy enough if the name column is formated as "first name, last name". You can use functions like LEFT, FIND, LEN and RIGHT. Because you didn't give enough information so cannot provide my example. It's something like this: Suppose the "First name, Last name" (Full name) column is A, a new "First name" column is B, and a new "Last name" column is C. --------------------------------------------- | A | B | C --------------------------------------------- 1 | Full name | First name | Last name --------------------------------------------- 2 |John, Smith | [first] | [last] --------------------------------------------- 3 | ... then: [first]=LEFT(A2,FIND(",",A2)-1) [last]=RIGHT(A2,LEN(A2)-FIND(", ",A2)) just copy this formula for the following records.