additional text after/before original text

[pcorpz]

How do i format a cell to add another text after the original text? I assume it is done by going to "custom", but I dont know what formula to put?

ex.

7UP Cherry

I want it to look like "7UP Cherry 6PK"

 

[DominicB]

Good evening pcorpz

Yes, you go to custom and enter @" 6PK"

Include the quotes.

HTH

DominicB

 

[pcorpz]

thanks dominic! that wasnt too hard!