I have a column that displays a person's lastname,firstname.
How can I separate it, so that one column is just the last name, and another
is the firstname.
I have a column that displays a person's lastname,firstname.
How can I separate it, so that one column is just the last name, and another
is the firstname.
Use Data | Text to Columns and use the comma as the delimiter
Regards
Trevor
"Metalteck" <[email protected]> wrote in message
news:[email protected]...
>I have a column that displays a person's lastname,firstname.
> How can I separate it, so that one column is just the last name, and
> another
> is the firstname.
Assuming your name is in A1.........
This will pull out the LastName.........=LEFT(A1,FIND(",",A1,1)-1)
And this will pull out the FirstName.. =MID(A1,FIND(",",A1,1)+1,99)
Then just copy these formulas down as far as you have data in column A.
Vaya con Dios,
Chuck,, CABGx3
"Metalteck" <[email protected]> wrote in message
news:[email protected]...
> I have a column that displays a person's lastname,firstname.
> How can I separate it, so that one column is just the last name, and
another
> is the firstname.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks