• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Adding a text/letter infront of numbers in numerous cells by using a formula

T

Trix

New Member
I need to add a text infront of the numbers/project number in a column of cells without inserting it one by one, for example, cell reads 145, needs to read PRJ145.


And there is a whole set of these project numbers, I need a quick way to add the ‘PRJ’ infront of the number to all cells at once.


Any help please?
 
hi Trix,


assuming data starts at A1, key in this formula in B1: ="PRJ"&A1


copy down to the whole column B.


the ampersand (&) is to concatenate/join the string "PRJ" with the cell content in A1
 
You must log in or register to reply here.
Back
Top