Here's an option. Go to the Format menu and select cells. In the Format Cells
dialog box select the number tab. From the Category list on the left select
Custom. In the line that says Type: you type PR### and close the dialog box.

The PR will automatically be placed in any cell you format with this custom
format and the ### is a place holder for any three numbers.

To apply this, select the cells you want to format. Select Format, Cells and
on the number tab select Custom and find your custom format from the bottom
of the list on the right.

Good luck!

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