Imported Formats

[CharlesF]

Our Accounting package exports to Excel but the fields are
all preceded with the Left Justification character, ie: " ' ".

How do I find all these and replace them. The Menu Item
Find says they do not exist.

Thank

 

[Bernie Deitrick]

Charles,

Select all your cells and run this macro:

Sub MacroForCharles()
Dim myCell As Range
On Error Resume Next
For Each myCell In Selection
myCell.Value = myCell.Text
Next myCell
End Sub

HTH,
Bernie
MS Excel MVP

 

[CharlesF]

Thanks Bernie!: