Is there a way to combine to text cells together without adding a new cell

Hi, I am new to excel and stuck trying to find we way a could combine two text cells together ie Add "|Discount" to the "Category_url" column.

I have created on a sample workbook but our real one has over 500 different rows in the "Category_url" column and from time to time we have to add certain product to the "discount" category so adding "discount" too each row would be very time consuming.

Creating a 4th column would not work either and the workbook will be saved to a csv file and upload to a database.



example.png

Hello and welcome to the forum,

Here's a suggestion :
1. In column C, type "|Discount" in the rows you need to modify
2. In column D, type the formula = B1 & C1 and copy down
3. Copy column D to column C, values only
4. Delete C and D

(Make a backup copy first if you need to get your category_url back without the "|Discount"