+ Reply to Thread
Results 1 to 6 of 6

adding the same prefix or suffix to a range of cells

Hybrid View

  1. #1
    SheriTingle
    Guest

    RE: adding the same prefix or suffix to a range of cells

    Sorry, I didn't see that Bill had already answered your question. : )

    "Betty Turvy" wrote:

    > How do you add the same prefix or suffix to a range of cells, without
    > changing the existing numbers in that range. ie. if you have these numbers
    > in a row of cells: 123 456 234 899
    > and you want them to read
    > PR123 PR456 PR234 PR899
    >
    > I want to add this PR prefix to all these numbers in a row of cells, without
    > typing the prefix into each cell. Thank you.
    >


  2. #2
    Bill Martin -- (Remove NOSPAM from address)
    Guest

    Re: adding the same prefix or suffix to a range of cells

    Don't ever be sorry for offering help to someone... You done good ;-)

    Bill
    --------------------
    SheriTingle wrote:
    > Sorry, I didn't see that Bill had already answered your question. : )
    >
    > "Betty Turvy" wrote:
    >
    >
    >>How do you add the same prefix or suffix to a range of cells, without
    >>changing the existing numbers in that range. ie. if you have these numbers
    >>in a row of cells: 123 456 234 899
    >>and you want them to read
    >>PR123 PR456 PR234 PR899
    >>
    >>I want to add this PR prefix to all these numbers in a row of cells, without
    >>typing the prefix into each cell. Thank you.
    >>


+ 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