#NAME? Error Fix?

[Martin Just]

Hi all. I'm importing a bunch of data from a .csv file. The host
application is not able to delimit the Customer Name field correctly, so for
some record types, I get values that look like:

=-- John Smith

Excel interprets this as a bad formula and returns #NAME? in the cell. I'm
trying to remove the leading characters using

If Left(ActiveCell.Value, 1) = "=" Then
ActiveCell.Value = Right(ActiveCell.Value,
Len(ActiveCell.Value) - 5)
End If

but get a Type Mismatch error. Any ideas how to tell Excel they are not
formulas?

Thanks much!

 

[Don Guillett]

Let us know if this works.

Sub cleanitup()
For Each c In Selection
x = c.Formula
If c.HasFormula Then c.Value = Right(x, Len(x) - 4)
Next
End Sub

 

[Martin Just]

Perfect! Thanks so much!

Let us know if this works.

Sub cleanitup()
For Each c In Selection
x = c.Formula
If c.HasFormula Then c.Value = Right(x, Len(x) - 4)
Next
End Sub

 

[Don Guillett]

Glad to help