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.