Stripping out non-numeric values from external data source

  • Thread starter Thread starter Eric Rydell
  • Start date Start date
E

Eric Rydell

Can Excel remove non-numeric characters from one field in
an external data source like a comma delimited file when
it is imported? Example: the field contains a space and a
dollar symbol then a numeric value, " $12345". We wish to
remove the " $" and import the numeric value.
 
After you import the data, you could just use
Edit|replace
and change the " $" to (leave blank)

Or do it in two steps--once for the space and once for the $.
 
Back
Top