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