Excel cell format?
By calvin222
@calvin222 (1606)
India
2 responses
@nguyenminh181 (81)
• 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.
