+ Reply to Thread
Results 1 to 3 of 3

placing numbers in front of existing numbers

  1. #1
    Registered User
    Join Date
    08-16-2010
    Location
    Studio City, CA1
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    1

    placing numbers in front of existing numbers

    I have an exported CSV file that needs to be uploaded into another system for a 911 database. I have over 4000 entries and in one column, I have the extension numbers of my users which is a 4 digit number. I need to place my 3 digit prefix in front of these 4 digit numbers for the database to work correctly. The 3 digit prefix is the same number for all cells. The merge cell doesn't work. I need to do this on a weekly basis, so hopefully there is a simple formula or feature that would work.

    Thanks for any input you may have.

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: placing numbers in front of existing numbers

    Maybe you can format the column to display the prefix (for viewing purposes only. I.e. the underlying number will stay in tact for calculation purposes, etc.).

    Select the column and go to Format|Cells and pick Custom

    then enter "xxx-"0 where xxx- within the quotes is the prefix to add.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    08-16-2010
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: placing numbers in front of existing numbers

    the concatenate function does exactly that:

    =CONCATENATE("911-";A1)

    Replace 911 with you extension.

+ 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