Re: $$Excel-Macros$$ Need a VBA code to display name in Last Name, First Name format

Hi Sharath, PFA, Hope it will help you. Divaker Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo Exit_Sub Dim nameIS() As String, newName As String If Target.Column = 6 And Target.Row 6 Then If IsEmpty(Target.Value) Then Exit Sub If InStr(Target.Value,

$$Excel-Macros$$ Need a VBA code to display name in Last Name, First Name format

Hello Experts, I have attached a spreadsheet. In Column F we have a name. By default it is validated in the format First Name (and Middle Name if exists) Last Name. So when someone types in a name in any of the cell in Column F, it should convert the format to Last Name, (comma) First (and