• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 12. Data Importing and Repairing > Replacing Inconsistent Formatting

Replacing Inconsistent Formatting

A straight Replace puts new data where old information once was. Sometimes, however, you only want to edit a portion of a record while leaving the rest of the field contents intact. That's when you need a calculation using the Substitute function.

For example, suppose you have a State field containing a variety of formats, like NY, N.J., Ca, and R.i. Searching for each state's variations would take so long you might as well input them by hand. The Substitute function replaces a letter, word or any other piece of data with another, leaving the rest of the field intact.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint