removing single quotes from a paste operation

[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?

 

[Guest]

Enter and run this small macro:

Sub tickout()
Dim r As Range
For Each r In Selection
r.Value = r.Value
Next
End Sub

 

[joeycalisay]

is this inefficient? are there any settings that i can just use?

 

[Jim Cone]

Paste "Values" by going to the Edit (menu) | Paste Special | Values
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"joeycalisay" <[email protected]>
wrote in message
is this inefficient? are there any settings that i can just use?

 

[joeycalisay]

hi jim, the quotes are still there with Paste Special | Values

 

[joeycalisay]

any other ideas?

hi jim, the quotes are still there with Paste Special | Values

 

[Tom Ogilvy]

Sub tickout()
Dim r As Range
For Each r In Selection
r.Value = r.Value
Next
End Sub

 

[Jim Cone]

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?