I have the following column: https://puu.sh/IVDy8/ed51bddbf7.png

I would replace to mass replace those numbers and add before them:

0x8604808b824c4444fe4df3f94850acd584c5ad7d|

So for example replace this: 368-4 with 0x8604808b824c4444fe4df3f94850acd584c5ad7d|368-4

Thank you

CodePudding user response：

Try an array formula:

=ArrayFormula(IF(A2:A="",,"0x8604808b824c4444fe4df3f94850acd584c5ad7d|"&A2:A))

CodePudding user response：

I managed to replace them by using search: ^ and replace with 0x8604808b824c4444fe4df3f94850acd584c5ad7d|