removing single quotes from a paste operation

  • Thread starter Thread starter joeycalisay
  • Start date Start date
J

joeycalisay

i have noticed that when data being pasted to an excel worksheet have
single quotes on all cells, it is being retained by excel. i just
want excel to treat all data as text. anyway to force excel to render
each cells without the single quotes?
 
Enter and run this small macro:

Sub tickout()
Dim r As Range
For Each r In Selection
r.Value = r.Value
Next
End Sub
 
Sub tickout()
Dim r As Range
For Each r In Selection
r.Value = r.Value
Next
End Sub
 
Try the Trim and Clean functions on them and then copy
and paste values again.
However, you said you wanted Excel to treat all data as text.
A leading apostrophe causes Excel to treat the data as text.
Excel also ignores that character when processing the data.
You may not have a problem?
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"joeycalisay" <[email protected]>
wrote in message
any other ideas?
 
Back
Top