If you can change all the #'s to nothing, just:

select the range
edit|replace
what: #
with: (leave blank)
replace all

This will get all of them--not just the prefix #'s.

Mort Snerd wrote:

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.

--

Dave Peterson