+ Reply to Thread
Results 1 to 5 of 5

Removing Certain Cell Contents

  1. #1
    Registered User
    Join Date
    04-11-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    2

    Removing Certain Cell Contents

    Hi, new to advanced editing in Excel so all help welcome.

    I have a cell that contains some codes, followed by a reference

    e.g.

    #AB123;#1234;#AB124;#1235

    I want to return the following;

    AB123; AB124

    so I need to remove the '#' and the 4 digit number where an AB is not present first.

    Any help would be great

    Cheers

    Chris

  2. #2
    Forum Contributor tkowal's Avatar
    Join Date
    11-20-2010
    Location
    Miami, Fl
    MS-Off Ver
    Excel 2010
    Posts
    150

    Re: Removing Certain Cell Contents

    Here is one way of doing it using a user defined function.

    StripParseString.xlsm
    Ted
    "Live Long and Prosper"

  3. #3
    Registered User
    Join Date
    04-11-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Removing Certain Cell Contents

    Cheers for that, almost worked fully (but my fault for not fully explaining the issue correctly)

    My first entry into the cell does not have a '#' in front so reads like below

    AB103;#1809;#AB107;#1813


    is it possible to still get this number? as with the string you provided it misses out the first set of numbers...cheers for any help

  4. #4
    Forum Expert
    Join Date
    09-27-2011
    Location
    Poland
    MS-Off Ver
    Excel 2007
    Posts
    1,312

    Re: Removing Certain Cell Contents

    Hi below my proposition of small UDF
    Please Login or Register  to view this content.
    Regards

    tom1977

    If You are satisfied with my solution click the small star icon on the left to say thanks.

  5. #5
    Forum Contributor tkowal's Avatar
    Join Date
    11-20-2010
    Location
    Miami, Fl
    MS-Off Ver
    Excel 2010
    Posts
    150

    Re: Removing Certain Cell Contents

    Ok using Toms logic/approach I modified the UDF to first strip # effectively ignoring them and then search for the occurance of "ABxxx". So this should work irespective of an #'s

    StripParseString_1.xlsm

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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