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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike C - 15 Mar 2008 16:30 GMT

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!

Reply to this Message

Gary''s Student - 15 Mar 2008 17:54 GMT

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

Signature

Gary''s Student - gsnu2007f

> Hello - I am trying to clean some data and need to change all of my
> names from
[quoted text clipped - 10 lines]
>
> Thanks for any suggestions!

Reply to this Message

Mike C - 16 Mar 2008 17:07 GMT

On Mar 15, 11:54 am, Gary''s Student
<GarysStud...@discussions.microsoft.com> wrote:

> Select the cells you want to change and run this tiny macro:
>
[quoted text clipped - 28 lines]
>
> - Show quoted text -

Thanks Gary

Reply to this Message

Rate this thread: