How to separate fname and fname in cell in excel
 

Can soneone help me to wright a formula that will separate lname and fname in cell "B" to Cell"A "=lname and cell"B"=fname. Thy are separate by comma and space in cell "B" in excel 2000.
My e-mail address is

How to separate fname and fname in cell in excel
 

Sub AABA()
Set cell = ActiveCell
If InStr(cell, ",") Then
iloc = InStr(cell, ",")
cell.Offset(0, -1).Value = Left(cell.Value, iloc - 1)
cell.Value = Right(cell.Value, Len(cell.Value) - (iloc + 1))
End If

End Sub

--
Regards,
Tom Ogilvy



"Excel Problem" <Excel wrote in message
...
Can soneone help me to wright a formula that will separate lname and
fname in cell "B" to Cell"A "=lname and cell"B"=fname. Thy are separate by
comma and space in cell "B" in excel 2000.
My e-mail address is

How to separate fname and fname in cell in excel
 

datatext to columns is probably the easiest
or
a macro

--
Don Guillett
SalesAid Software

"Excel Problem" <Excel wrote in message
...
Can soneone help me to wright a formula that will separate lname and
fname in cell "B" to Cell"A "=lname and cell"B"=fname. Thy are separate by
comma and space in cell "B" in excel 2000.
My e-mail address is