Evey cell in column is different but prefix is the same. Word needs to be this way:

"R1" - prefix
"something" - word entered in cell

and final result "R1something"