| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
removing single quotes from a paste operation
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
removing single quotes from a paste operation
Enter and run this small macro:
Sub tickout() Dim r As Range For Each r In Selection r.Value = r.Value Next End Sub -- Gary''s Student gsnu200704 "joeycalisay" wrote: 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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
removing single quotes from a paste operation
is this inefficient? are there any settings that i can just use?
On Feb 7, 6:22 pm, Gary''s Student wrote: Enter and run this small macro: Sub tickout() Dim r As Range For Each r In Selection r.Value = r.Value Next End Sub -- Gary''s Student gsnu200704 "joeycalisay" wrote: 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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
removing single quotes from a paste operation
Paste "Values" by going to the Edit (menu) | Paste Special | Values -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "joeycalisay" wrote in message is this inefficient? are there any settings that i can just use? On Feb 7, 6:22 pm, Gary''s Student wrote: Enter and run this small macro: Sub tickout() Dim r As Range For Each r In Selection r.Value = r.Value Next End Sub -- Gary''s Student gsnu200704 "joeycalisay" wrote: 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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
removing single quotes from a paste operation
hi jim, the quotes are still there with Paste Special | Values
On Feb 7, 11:22 pm, "Jim Cone" wrote: Paste "Values" by going to the Edit (menu) | Paste Special | Values -- Jim Cone San Francisco, USAhttp://www.realezsites.com/bus/primitivesoftware "joeycalisay" wrote in message is this inefficient? are there any settings that i can just use? On Feb 7, 6:22 pm, Gary''s Student wrote: Enter and run this small macro: Sub tickout() Dim r As Range For Each r In Selection r.Value = r.Value Next End Sub -- Gary''s Student gsnu200704 "joeycalisay" wrote: 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? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
removing single quotes from a paste operation
any other ideas?
On Feb 8, 2:25 pm, "joeycalisay" wrote: hi jim, the quotes are still there with Paste Special | Values On Feb 7, 11:22 pm, "Jim Cone" wrote: Paste "Values" by going to the Edit (menu) | Paste Special | Values -- Jim Cone San Francisco, USAhttp://www.realezsites.com/bus/primitivesoftware "joeycalisay" wrote in message is this inefficient? are there any settings that i can just use? On Feb 7, 6:22 pm, Gary''s Student wrote: Enter and run this small macro: Sub tickout() Dim r As Range For Each r In Selection r.Value = r.Value Next End Sub -- Gary''s Student gsnu200704 "joeycalisay" wrote: 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? |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
removing single quotes from a paste operation
Sub tickout()
Dim r As Range For Each r In Selection r.Value = r.Value Next End Sub -- Regards, Tom Ogilvy "joeycalisay" wrote in message oups.com... any other ideas? On Feb 8, 2:25 pm, "joeycalisay" wrote: hi jim, the quotes are still there with Paste Special | Values On Feb 7, 11:22 pm, "Jim Cone" wrote: Paste "Values" by going to the Edit (menu) | Paste Special | Values -- Jim Cone San Francisco, USAhttp://www.realezsites.com/bus/primitivesoftware "joeycalisay" wrote in message is this inefficient? are there any settings that i can just use? On Feb 7, 6:22 pm, Gary''s Student wrote: Enter and run this small macro: Sub tickout() Dim r As Range For Each r In Selection r.Value = r.Value Next End Sub -- Gary''s Student gsnu200704 "joeycalisay" wrote: 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? |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
removing single quotes from a paste operation
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" wrote in message any other ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change cut/paste operation to cut/insert operation | Excel Programming | |||
| my code is adding single quotes | Excel Programming | |||
| my code is adding single quotes | Excel Programming | |||
| Single quotes in named range | Excel Worksheet Functions | |||
| Magical appearance of single quotes. | Excel Programming | |||
Linear Mode
