software

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 quot;#(value)quot; with quot;(value),quot;.

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.

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:
gt;
gt; I am trying to manipulate some imported text/data on a spreadsheet. My
gt; problem seems simple enough but I have not been able to come across
gt; the solution by myself.
gt;
gt; I have a column of numbers preceded by a # sign. I would like to
gt; simply replace all quot;#(value)quot; with quot;(value),quot;.
gt;
gt; If I use find #??? and replace with ???, I get a literal replacement
gt; showing question marks or asterisks instead of the numeric value
gt; represented by the wildcards.
gt;
gt; I'm sure there must be a simple soluton but I can't find it.
gt;
gt; TIA for any assistance.

--

Dave Peterson

This formula will do the job -
=IF(LEN(A4)=2,RIGHT(A5,1),IF(LEN(A4)=3,RIGHT(A5,2) ,IF(LEN(A4)=4,RIGHT(A4,3),IF(LEN(A4)=5,RIGHT(A4,4) ))))
for cells with up to 5 characters.

Regards.

Bill Ridgeway
Computer Solutions

quot;Mort Snerdquot; gt; wrote in message
...
gt;I am trying to manipulate some imported text/data on a spreadsheet. My
gt; problem seems simple enough but I have not been able to come across
gt; the solution by myself.
gt;
gt; I have a column of numbers preceded by a # sign. I would like to
gt; simply replace all quot;#(value)quot; with quot;(value),quot;.
gt;
gt; If I use find #??? and replace with ???, I get a literal replacement
gt; showing question marks or asterisks instead of the numeric value
gt; represented by the wildcards.
gt;
gt; I'm sure there must be a simple soluton but I can't find it.
gt;
gt; TIA for any assistance.