I am trying to manipulate some imported text/data on a spreadsheet. My
problem seems simple enough but I have not been able to come across
the solution by myself.

I have a column of numbers preceded by a # sign. I would like to
simply replace all "#(value)" with "(value),".

If I use find #??? and replace with ???, I get a literal replacement
showing question marks or asterisks instead of the numeric value
represented by the wildcards.

I'm sure there must be a simple soluton but I can't find it.

TIA for any assistance.