MadHatsJess
New Member
- Joined
- Jul 12, 2017
- Messages
- 27
Hi
I have a very large data set with customer nationalities. I need to clean the nationalities up as there are several variations.
For example France should be French, British National should be British.
I can easily do this however I will be refreshing the data daily and am looking for an automated way.
I have made a table listing "From and To".
Can anyone help?
I was thinking of recording a macro and using the find and replace function but I think it would take too long as the list is quite big. (I am not the best with Macros so couldn't write it)
Thanks![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I have a very large data set with customer nationalities. I need to clean the nationalities up as there are several variations.
For example France should be French, British National should be British.
I can easily do this however I will be refreshing the data daily and am looking for an automated way.
I have made a table listing "From and To".
Can anyone help?
I was thinking of recording a macro and using the find and replace function but I think it would take too long as the list is quite big. (I am not the best with Macros so couldn't write it)
Thanks