How to separate fname and fname in cell in excel

[Guest]

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 (e-mail address removed)

 

[Tom Ogilvy]

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

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.

 

[Don Guillett]

data>text to columns is probably the easiest
or
a macro

--
Don Guillett
SalesAid Software
(e-mail address removed)

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.