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.

Stripping out non-numeric values from external data source
 

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 $.

Eric Rydell wrote:

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.

--

Dave Peterson