Removing specific charectors

[wmtsub]

How would I search colum n and remove "-" from all cells in the range N2-[lastrow]?

 

[Rick Rothstein]

How would I search colum n and remove "-" from all cells in the range N2-[lastrow]?

Does cell N1 have dashes in it that must be preserved?

Are you looking for a macro solution or a manual procedure?

 

[wmtsub]

it is a list of #'s and I would like to remove anything that is not a number. A macro would be preferred.

 

[Rick Rothstein]

it is a list of #'s and I would like to remove anything that is not a number. A macro would be preferred.

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.

 

[wmtsub]

the "-" is my main concern. The other was an after thought.

 

[Rick Rothstein]

the "-" is my main concern. The other was an after thought.

Here is a macro that will remove all dashes from Column N starting at Row 2...

[table="width: 500"]
[tr]
	[td]Sub RemoveDashesFromColumnN()
  Range("N2", Cells(Rows.Count, "N").End(xlUp)).Replace "-", "", xlPart,,,,False
End Sub[/td]
[/tr]
[/table]

 

[wmtsub]

than you