Does cell N1 have dashes in it that must be preserved?How would I search colum n and remove "-" from all cells in the range N2-[lastrow]?
Your original post said you wanted to remove dashes from Column N but the above makes it sound like you have text other than dashes mixed with the numbers... is that the case? If so, is the other text simply other symbols (like slashes, colons, etc.) or are we talking varying text (like words)? Please describe what is in the cells (numbers in some, text in others, a mix of text and numbers in some others) so we know what we have to work around. Remember, we cannot see your work sheet so we have no idea what your data looks like... all we know is what you tell us, so be complete when describing your data.it is a list of #'s and I would like to remove anything that is not a number. A macro would be preferred.
Here is a macro that will remove all dashes from Column N starting at Row 2...the "-" is my main concern. The other was an after thought.
[table="width: 500"]
[tr]
[td]Sub RemoveDashesFromColumnN()
Range("N2", Cells(Rows.Count, "N").End(xlUp)).Replace "-", "", xlPart,,,,False
End Sub[/td]
[/tr]
[/table]