+ Reply to Thread
Results 1 to 3 of 3

Macro Remove Unwanted Data

  1. 11-13-2013, 06:19 AM #1
    timbo1957
    timbo1957 is offline
    Valued Forum Contributor
    Join Date
    11-15-2007
    Location
    England
    MS-Off Ver
    Office Pro 2003 / 2010
    Posts
    423

    Macro Remove Unwanted Data

    Hi,

    I have a report which is sent to me from an outssde supplier which has a column of numbers like this -

    ISBN-13 9780715338360
    ISBN 0486272982
    ISBN-13 9781440309311
    ISBN-13 9780715336267
    ISBN 0486444651
    ISBN-13 9781440330179
    ISBN-13 9780715329542
    ISBN-13 9781446302842
    ISBN 0486282406
    ISBN-13 9781446303207
    ISBN 1580627560
    ISBN-13 9781446303238
    ISBN-13 9781446303849
    ISBN-13 9781446301371
    ISBN-13 9780715338650
    ISBN-13 9780715336243
    ISBN-13 9780486490977
    ISBN 0715325507

    There are over 14,000 rows of data and one of these for each row in column C of the report.

    I need a macro that will remove any text, dashes and spaces but not any leading zeros from each number and leave me with a clean column of numbers.

    NOTE: that includes the 13 where there is an ISBN-13.

    I need it to be a macro because it needs to be part of a much larger process whichy is macro driven.

    Could someone help please?
    Last edited by timbo1957; 11-13-2013 at 06:21 AM.
    Reply With QuoteRegister To Reply
  2. 11-13-2013, 06:46 AM #2
    ragulduy
    ragulduy is offline
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Macro Remove Unwanted Data 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 11-14-2013, 06:01 AM #3
    timbo1957
    timbo1957 is offline
    Valued Forum Contributor
    Join Date
    11-15-2007
    Location
    England
    MS-Off Ver
    Office Pro 2003 / 2010
    Posts
    423

    Re: Macro Remove Unwanted Data

    Many Thanks yudlugar.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to remove unwanted data & rearrange last name & first name in a cell
    By rbecker69 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-20-2013, 03:12 AM
  2. [SOLVED] Need macro to remove unwanted data from large tables
    By s4driver in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 04-26-2013, 08:07 AM
  3. [SOLVED] MACRO to remove unwanted character.
    By visha_1984 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-07-2013, 03:47 AM
  4. Macro to change cell format to text and remove unwanted spaces & special characters
    By Chito in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-17-2012, 05:30 AM
  5. remove unwanted data
    By ahmedalhoseny in forum Excel General
    Replies: 1
    Last Post: 06-14-2010, 04:51 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1