I cant use the .csv/l5k files and find/replace text as that is not quite what I want to do, the tags do not all begin with the same letter/symbol.
Don't use find and replace .... Use the power of Excel to CONCAT Cells :nodi:
Write formula to in A1 as take ="PLC1_"+B1 and then pasted down column A:A and then once updated all cells Copy the Column A:A and Paste back into Column A:A as Values .. Delete Column B:B