How can I add prefixes in Microsoft Excel?
I am a data analyst and I have assigned a task which is related to the analysis of a database by using a Microsoft Excel sheet that contains a column of product codes I need to add a specific prefix in each code in that column (let’s say PRD). How can I efficiently achieve this particular objective by using Excel functions and tools?
Excel is one of the most powerful database tools for professionals like data analysts. Under Excel, if you want to change prefixes or add prefixes in Excel, then follow several points which are given below:-
By using the CONCATENATE function or & Operator
Assume that your data starts in cell A2 In the adjacent cell A2, the adjacent column let's say is B2, use the formula = CONCATENATE(“PRO A2) or =PRD _ “&A2. After typing the formula apply it to the cells.
Copy and paste values Once the prefix is CONCATENATE in column B, you can copy these values and then paste them over the column which is original for replacing the existing values.