Replace a comma with a period in a cell containing a lastname, first

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!

GarysStudent
Sat Mar 15 11:54:00 CDT 2008

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


"Mike C" wrote:

> 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!
>

Mike
Sun Mar 16 11:07:01 CDT 2008

On Mar 15, 11:54=A0am, Gary''s Student
<GarysStud...@discussions.microsoft.com> wrote:
> Select the cells you want to change and run this tiny macro:
>
> Sub comma_tose()
> For Each r In Selection
> =A0 =A0 v =3D StrReverse(r.Value)
> =A0 =A0 r.Value =3D 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
>
>
>
> "Mike C" wrote:
> > 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 andreplaceformula =A0or method of som sort (in
> > excel or access) that will allow me to pull the firstcommafrom the
> > right andreplaceit with aperiod.
>
> > Thanks for any suggestions!- Hide quoted text -
>
> - Show quoted text -

Thanks Gary