Hi All
I am trying to remove some superfluous text from a list of names.
ie.
current: John Brown (AUS), Joe Bloggs (NZ), Sue Smith nz., Ruby Red New Zealand
desired: John Brown, Joe Bloggs, Sue Smith, Ruby Red.
http://i.imgur.com/qLmCyAE.png
In column E of the sample list, ive tried to account for all of these possibilities.
The list of text to remove is quite long (longer than the sample in column E), so i was hoping there was a formula(s) or macro that would assist me rather that having to individually 'Find & Replace'.
If anyone can assist, that would be great.
Thanks!
Bookmarks