changing numbers in a formula

[Todd]

Hi. I have a lot of formulas that contain numbers &
symbols that I want to replace. Can I use a macro to do
that? I have working with

Sub ReplaceCRLF()
Selection.Replace Chr(43), Chr(44), xlWhole 'xlWhole
apply to entire cell content
End Sub

In this case I am exchanging "+" 's for ","

Which I got from dmc ritchie's website. It doesn't work
yet.


Thanks,

Todd

 

[Mike]

Change xlWhole to xlPart.
xlWhole means it's looking for a cell who's entire
contents is the search value. So this would only work on
a cell if all it contained is a +. You only want to look
for a part of the cell that contains the search value.