We are changing the way we record our client relationship owners. Up to now, we have recorded this information via a text field, but want to use a lookup field. I created the lookup field, but I don't know how to get all the information previously stored in the text field populated in the lookup field. Is there a way to do this automatically, or is this just going to be a massive copy and paste job?
Not in SFDC, you'll need to export the data to Excel or some other tool and do a VLOOKUP to match the Text value to the Lookup(Id) value, then import/update the Lookup field in SFDC
