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 M

Re: $$Excel-Macros$$ Need a VBA code

dear Sharath Pl share u r data with us... Regards, Gawli Anil On Wed, Jun 27, 2012 at 3:21 PM, sharath chandra < sharath.c.sambr...@gmail.com> wrote: > > Hello Experts, > > I need a quick VBA code. We have column where we enter a name in "First > Name Last Name" format. When someone enters a name

$$Excel-Macros$$ Need a VBA code

Hello Experts, I need a quick VBA code. We have column where we enter a name in "First Name Last Name" format. When someone enters a name in that cell, it should automatically display the name in the same cell in the "Last Name, First Name" format (which is Outlook format). Please let me know