If the prefix or suffix is not going to be constant you could use the
Concatenate function. For example, if your data is in A1:D1, in cell E1 you
could type PR. Then in Cell A2 type =$E$1&A1 and copy to Cells B2:D2. You
could also simply type = "PR"&A1 in A2 and copy to B2:D2. Finally, copy
A2:D2 and edit/paste special/values in A1. However, this will change your
numbers to Text. HTH
--
Sincerely, Michael Colvin


"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.