Removing "," between First & Last Names

  • Thread starter Thread starter Fran
  • Start date Start date
F

Fran

I have the following data in a field called "named":
John,Smith
Bob, Davis
Juli, Orr

I would like to remove the "," between the first and last
name. In the example above the first name is "John" and
the last name is "Smith".

How can I do this using Access 2002.


Thanks
 
Back
Top