Results 1 to 11 of 11

Removing a set of unwanted characters from a column

Threaded View

  1. #1
    Registered User
    Join Date
    01-02-2012
    Location
    Melbourne
    MS-Off Ver
    Excel 2003
    Posts
    63

    Removing a set of unwanted characters from a column

    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!
    Attached Files Attached Files
    Last edited by Rob8489; 07-21-2013 at 09:23 PM. Reason: forgot attachement

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Removing Unwanted Characters & Moving Others
    By bdb1974 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-10-2009, 10:09 AM
  2. removing unwanted characters
    By djbetterly in forum Excel General
    Replies: 4
    Last Post: 05-06-2008, 12:22 PM
  3. [SOLVED] Removing unwanted characters
    By Richard in forum Excel General
    Replies: 2
    Last Post: 06-23-2006, 02:40 PM
  4. Removing unwanted characters
    By jermsalerms in forum Excel General
    Replies: 15
    Last Post: 01-19-2006, 05:20 PM
  5. Removing unwanted characters
    By Scorpvin in forum Excel General
    Replies: 8
    Last Post: 12-05-2005, 05:10 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1