+ Reply to Thread
Results 1 to 2 of 2

Add a alphabetic character to the beginning of an entire column of

  1. #1
    Karise
    Guest

    Add a alphabetic character to the beginning of an entire column of

    I have one column column of numbers that I want to add a letter to the front
    of the numbers.
    Help?

  2. #2
    Chip Pearson
    Guest

    Re: Add a alphabetic character to the beginning of an entire column of

    In a new column, enter the formula

    ="letter"&A1

    Change the A1 to the appropriate cell, and fill down the formula
    as far as you need to go. Then, select the cells in the new
    column, copy them, and Paste Special (from the Edit menu) and
    choose Values Only.


    --
    Cordially,
    Chip Pearson
    Microsoft MVP - Excel
    Pearson Software Consulting, LLC
    www.cpearson.com




    "Karise" <Karise@discussions.microsoft.com> wrote in message
    news:DDE68129-A198-4810-ADDD-33F0DD179FB0@microsoft.com...
    >I have one column column of numbers that I want to add a letter
    >to the front
    > of the numbers.
    > Help?




+ 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