I have a column with a last and a first names as follows

Employee Name
Thibodeau, Cheryl
Milan, Nick
Chian, Mary
Janzen, Eliane
.....

I need to sort it by the first name, which is the second word after the coma.

How could I do this?

Thanks

Give this function a try...

Public Function FormatName(ByVal InputName As String) As String
FormatName = Right(InputName, Len(InputName) - InStrRev(Trim(InputName),
" ")) & _
", " & Trim(Left(InputName, InStrRev(InputName, " ")))
End Function

"Alex" wrote:

I have a column with a last and a first names as follows

Employee Name
Thibodeau, Cheryl
Milan, Nick
Chian, Mary
Janzen, Eliane
....

I need to sort it by the first name, which is the second word after the coma.

How could I do this?

Thanks

Sorry the last function I Posted Changes names into to what you wnat to
convert them from... :-) Dopey Me...

"Alex" wrote:

I have a column with a last and a first names as follows

Employee Name
Thibodeau, Cheryl
Milan, Nick
Chian, Mary
Janzen, Eliane
....

I need to sort it by the first name, which is the second word after the coma.

How could I do this?

Thanks

Use datatext to column to split or a helper column with the first name
only.

Sub namesplit()
For Each n In Selection
n.Offset(, 1) = Right(n, Len(n) - InStr(n, ","))
Next
End Sub

--
Don Guillett
SalesAid Software

"Alex" wrote in message
...
I have a column with a last and a first names as follows

Employee Name
Thibodeau, Cheryl
Milan, Nick
Chian, Mary
Janzen, Eliane
....

I need to sort it by the first name, which is the second word after the
coma.

How could I do this?

Thanks