+ Reply to Thread
Results 1 to 3 of 3

Remove - From List of UPC

  1. 02-22-2018, 08:02 PM #1
    forestavekids
    forestavekids is offline
    Forum Contributor
    Join Date
    10-10-2015
    Location
    nj
    MS-Off Ver
    Office 2021
    Posts
    203

    Remove - From List of UPC

    Hi All,

    Have a column of UPC 12 digit codes that have the - in the middle of them. Some cells also have multiple UPC code.

    Any way to single this down to 1 cell per UPC and remove the - sign?

    Please see attached.

    Thanks!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-22-2018, 08:46 PM #2
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: Remove - From List of UPC

    You can try with PowerQuery - two ways: vertical or horizontal
    Attached Files Attached Files
    Last edited by sandy666; 02-22-2018 at 08:54 PM. Reason: file updated
    Reply With QuoteRegister To Reply
  3. 02-22-2018, 09:02 PM #3
    leelnich
    leelnich is offline
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Remove - From List of UPC

    Here's a macro that puts the new values in column B. Note that the new values are formatted as TEXT. If you want numbers, remove the red line. 
    Please Login or Register  to view this content.
    BTW, there are a few duplicated values. Would you like to remove the extras? If so, use the following instead: 
    Please Login or Register  to view this content.
    Last edited by leelnich; 02-22-2018 at 09:26 PM.
    Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
    Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee
    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. 2 lists need to remove list B data from list A - how??
    By grahamg16 in forum Excel General
    Replies: 5
    Last Post: 05-14-2015, 04:47 AM
  2. Remove items from DV list once used, display elsewhere. Reset list when filling across.
    By HSmith88 in forum Excel General
    Replies: 1
    Last Post: 09-14-2013, 04:55 AM
  3. have vba remove values from one list based on entries from another list
    By frugal in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-11-2013, 06:36 AM
  4. Formula to remove words from list A that are listed in list B
    By acoustics in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-23-2013, 08:14 AM
  5. Remove Certain Information From a List and Auto Create New List On Other Sheet
    By unpluggedmusic in forum Excel General
    Replies: 3
    Last Post: 12-01-2012, 05:22 AM
  6. Remove empty cells from named list / validation list
    By Sp00k in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-28-2006, 10:45 AM
  7. [SOLVED] How to remove duplicates from a list and copy new list to new colu
    By Chance in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-23-2005, 01:07 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