How best to copy contents of one column to a different column?
I have a numeric column in Deals that I need to copy ("move") into a single-line string column. When the copy operation is complete, I will delete the original numeric column.
I have about 900 Deal records.
I know I could do this by exporting the Deals, use excel to do the "copy", then reimport using the "Opportunity ID" as the key...but I've yet to do a mass data update this way and I always get twitchy when doing a global update.
Are there better ways to do what I need?