View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eric Rydell Eric Rydell is offline
external usenet poster
 
Posts: 1
Default Stripping out non-numeric values from external data source

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.