+ Reply to Thread
Results 1 to 4 of 4

Copy specific number of digits from column to column

Hybrid View

cbridges Copy specific number of... 03-27-2011, 01:54 PM
nimrod Re: Copy specific number of... 03-27-2011, 02:47 PM
barryleajo Re: Copy specific number of... 03-27-2011, 04:05 PM
cbridges Re: Copy specific number of... 03-27-2011, 04:30 PM
  1. #1
    Registered User
    Join Date
    12-22-2009
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    14

    Copy specific number of digits from column to column

    Hi all,
    I have what is hopefully a simple question. I have an excel table filled with customer numbers and addresses (column A is customer number and B is address).
    Example of column A customer numbers
    Column A
    2014564.001
    2014589.002
    2016897.025

    This table will link to an ARCGIS mapping program to associate certain things to a physical address. The first 7 digits in the customer number (column A) will never change (they are associated with the physical address). The last 3 digits after the decimal will change based on customer - which I will not need.

    What I want to do is copy the first 7 digits from column A to column C. I can then use column C as my link to the physical address. I have tried to just format the column to a number with no decimal, however it will round up the last number in some instances. I will update this table once a month and was hoping there is an easy way to do this (there are thousands of customer numbers and addresses).
    Thanks in advance!
    Last edited by cbridges; 03-27-2011 at 04:29 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2003
    Location
    British Columbia , Canada
    MS-Off Ver
    03,07,10,13
    Posts
    727

    Re: Copy specific number of digits from column to column

    Formula Method: =LEFT(A1,7)


    Excel Tool Method : Use "Text to Column" with "." as your delim to do the entire column all at once.

  3. #3
    Valued Forum Contributor
    Join Date
    06-19-2010
    Location
    Holywell, N Wales, UK
    MS-Off Ver
    Excel 2013
    Posts
    470

    Re: Copy specific number of digits from column to column

    With acknowledgements to nimrod's advice but mindful that
    (there are thousands of customer numbers and addresses)
    the attached is a macro version which may help
    barry
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    12-22-2009
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Copy specific number of digits from column to column

    Quote Originally Posted by nimrod View Post
    Formula Method: =LEFT(A1,7)


    Excel Tool Method : Use "Text to Column" with "." as your delim to do the entire column all at once.
    Thank you nimrod...this will do exactly what I need!

+ 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