Find and Replace in a column
 

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.

Find and Replace in a column
 

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

Find and Replace in a column
 

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

"Mort Snerd" wrote in message
...
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.