Correcting a typo in large value list

[Val]

I'm new to Project so this may be simple. I have several project files that
the value list for a Text column was incorrectly entered. Is there a way I
can add a string prefix to all 200+ values in the list? For example, the
data I have in the Text13 column is "1.3.1" and I want "ABC.1.3.1". I've
tried to do a formula but I keep getting a recursive error since I need the
new value to be in Text13 plus I need to keep the ability to be able to
select a new value from the list (in case something changes). If it was
Excel, this would be simple because I'd just convert the formula to Paste
Values and be done.

Any help is appreiciated!!!

 

[Jack Dahlgren MVP]

You can copy the column, then paste in excel, convert then paste back.

-Jack Dahlgren

 

[Val]

Thanks that worked as long as I selected the 1st and last cell in the column.
I tried pasting the column but that locked up project.