Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Feb 2004
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    fill column (2000)

    Good Afternoon everybody!

    How are we today?

    A user has a column of data. In each of these cells, there are different numbers. This particular user would like to add a 1 to the beginning of each cell, w/o affecting the content of each cell. So in other words, the contents in each cell is a phone number. So, now that she wants to add a "1" to the beginning of each cell, she would want's to know if there is a way similar to auto fill, so she doesn't have to do it manually. Is there a way? or would it have to be done manually. Thanks!

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: fill column (2000)

    You'll need to insert an extra column for this solution.
    Step 1 - Insert column beside column of phone numbers
    Step 2 - Starting at the top, in the new empty column enter the formula <font color=red>"=1&</font color=red><font color=blue>cellreference</font color=blue>". Cell reference is, of course a reference to the first phone number in the column beside it.
    Step 3 - autofill the formula down the column
    Step 4 - copy the cells with the formula in them
    Step 5 - Use Paste Special/<font color=red>Values</font color=red> to replace the formula with the results.
    Step 6 - Delete the extra column.

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    New Lounger
    Join Date
    Feb 2004
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: fill column (2000)

    I'll give it a try.. thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •