Replace a comma with a period in a cell containing a lastname, firstname, middle i

  • Thread starter Thread starter Mike C
  • Start date Start date
M

Mike C

Hello - I am trying to clean some data and need to change all of my
names from

McLaughlin, Victor, (i.e, comma) W

to

McLaughlin, Victor.(i.e., period) W

Is there an extract and replace formula or method of som sort (in
excel or access) that will allow me to pull the first comma from the
right and replace it with a period.

Thanks for any suggestions!
 
Select the cells you want to change and run this tiny macro:

Sub comma_tose()
For Each r In Selection
v = StrReverse(r.Value)
r.Value = StrReverse(Replace(v, ",", ".", 1, 1))
Next
End Sub

For example:
a,b,c,d
will be changed to:
a,b,c.d
 
Select the cells you want to change and run this tiny macro:

Sub comma_tose()
For Each r In Selection
    v = StrReverse(r.Value)
    r.Value = StrReverse(Replace(v, ",", ".", 1, 1))
Next
End Sub

For example:
a,b,c,d
will be changed to:
a,b,c.d
--
Gary''s Student - gsnu2007f








- Show quoted text -
Click to expand...

Thanks Gary
 
Back
Top