+ Start a Discussion
sftechlearnersftechlearner 

Cleaning up Billing State field in Account?

Hi ,

I am trying clean up the Billing State(Account field) . The billing state has lot of incorrect values or lower case abbreviated values.
And we would like to have it as a two letter value for all the accounts such as (CA,IL,TX..)

What are best ways to approach this issue?

Thx.
Deepak Kumar ShyoranDeepak Kumar Shyoran
You can use a developer console to replace all these incorrect value with 2 word value. For example can replace California with CA , Texas to TX and so on.