Hello.
When we imported legacy data from an old system to CRM the Zip Code field contained mixed entires - either zip code, zip+4, or zip+4 without the extra four digits.
The Zip Code was imported in as Single Line Text (20 characters max).
We need to change all the zip codes so the read as only five characters. I created a new field called NewZip (also Single Line Text - 20 characters max)
I exported the Client records to Excel (XML format) selecting the option that includes the columns to allow me to reimport. I planned to make the modifications by runnning a =left command.
When I load the file in Excel and enter =left(n2,5) in a cell in the new NewZip column, it doesn't perform the function, it just leaves the txt as is.
How can I manipulate the txt in one column into the new column?
Thanks
Ed Fishman
*This post is locked for comments
I have the same question (0)
