Find and Replace in a column

[Mort Snerd]

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]

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.

 

[Bill Ridgeway]

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