Remove of '

  • Thread starter Thread starter Unknown User
  • Start date Start date
U

Unknown User

How to remove the symbol sign like ' when the data is exporting from
accounting software to excel? I did tried from replaced method but it
doesn't work as the format of the file.

Your assistance is really help. Thank you.
 
try this macro

Select the range and run the macro

Sub quote()
For Each r In Selection
With r
..Value = .Value
End With
Next
End Sub
 
Sorry I don't understand and I am not familiar in macro. Anyone could help
for this? Thank you.
 
Where do you see that sign?

Can you give an example?

If it is in Excel cell then you can replace it...
 
The sign is show in excel cell just before the context. The replace method
is doesn't work as the sign could be see on fx (formula bar) but not be see
 
Ok.

The ' before the value in the cell makes the value in the cell as TEXT so
even if it contains 123 Excel will treat it as a string "123".

To get rid of ' select the Col
Choose Data|Text to columns
Press Next twice
Click on General and click Finish
 
Thank you it work.

Sheeloo said:
Ok.

The ' before the value in the cell makes the value in the cell as TEXT so
even if it contains 123 Excel will treat it as a string "123".

To get rid of ' select the Col
Choose Data|Text to columns
Press Next twice
Click on General and click Finish
Click to expand...
 
Back
Top