Imported Formats

C

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
 
B

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
 
Top