Results 1 to 17 of 17

Copy 10 digits in a numbers and paste to another column

Threaded View

  1. #1
    Registered User
    Join Date
    03-10-2015
    Location
    Philippines
    MS-Off Ver
    2010
    Posts
    85

    Copy 10 digits in a numbers and paste to another column

    Hello,

    please help me to edit my code i need to copy 10 digits of number in column W

    raw data
    
    column W                       column X
                                         56883088845688308885
                                         5606667478
                                         568831077656883104645688311506
    
    Finish
    
    column W
    5688308884
    5688308885
    5606667478
    5688310776
    5688310464
    5688311506
    I've also attached my file.

    THanks
    Attached Files Attached Files
    Last edited by 6StringJazzer; 10-28-2016 at 02:09 PM. Reason: code tags to preserve spacing of data

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel copy two numbers between specific column and paste in next sheet.
    By visha_1984 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-15-2015, 05:41 AM
  2. Macro to find numbers in column and copy/paste to other sheet
    By maxbeard in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-10-2013, 11:28 AM
  3. compare 2 different numbers and copy the last 3 digits.
    By Aranell in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-28-2013, 05:04 AM
  4. [SOLVED] Copy paste rows (with numbers under column A) from one sheet to another
    By sn79 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-04-2013, 04:50 PM
  5. [SOLVED] Copy certain values (9 digits, numbers only) from range
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 05-11-2012, 12:24 PM
  6. Insert Digits Into A Column of Numbers
    By grayfox in forum Excel General
    Replies: 4
    Last Post: 02-16-2008, 03:30 PM
  7. Replies: 3
    Last Post: 02-27-2007, 08:46 PM

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