+ Reply to Thread
Results 1 to 3 of 3

how to add a constant prefix to an existing list of populated cells

  1. #1
    Registered User
    Join Date
    01-23-2010
    Location
    tucson, arizona
    MS-Off Ver
    Excel 2003
    Posts
    1

    Question how to add a constant prefix to an existing list of populated cells

    I have a single column of different numbers in 33,000 rows. I need to add a prefix in front of each number for all 33,000 numbers. The prefix is BB/. I have tried the 'replace' command tool which does work but far too time consuming for all those different numbers. Is there a shortcut to achieve this ?

  2. #2
    Forum Contributor
    Join Date
    02-14-2007
    Location
    Chester, England
    MS-Off Ver
    2010 & 2016
    Posts
    312

    Re: how to add a constant prefix to an existing list of populated cells

    Hello

    If the data is in Column A for example and starts in row 2 put this formula in a blank column.

    ="BB/"&A2

    Now copy this formula down

    hope this helps

    Jim

  3. #3
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: how to add a constant prefix to an existing list of populated cells

    Or you can format the cells as "BB/"General
    Entia non sunt multiplicanda sine necessitate

+ 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