How to remove unique ID numbers from name field after import?

(0) Share

Report

Posted on by RachelS

Hello,

I wondered if anybody might be able to help me. I am new to crm 2011 and have currently been working at importing organisations (accounts) and contacts - I now have these importing correctly and did so by adding a unique ID number to the data before import - however this ID number shows within the organisation name - for example: Smith Family ID353 will appear in the organisation name field.visually (for invoices etc) it would be better if these ID numbers are removed from the names and I wondered if anybody could suggest how I go about doing this?

many thanks

Rachel

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

jlattimer 24,564 on at

Like (0)

Report
Copy link

Link copied!

Use Advanced Find to search and find all Account records that contain "ID*". Use the export feature (Excel icon) from the results to export and use the option at the bottom to make the data available to re-import. Also make sure the name field you want to edit is in the list of columns returned. Use Excel to remove the IDXXX values. There is probably a few ways to go about it. Create a new column for name and insert a formula like: =LEFT(A1,LEN(A1)-7)

Then go to Setting -> Data Management -> Import and import the saved file.

Was this reply helpful? Yes No