If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
adding apostrophe macro?
I download a .csv sheet daily, open & save as excel, and link to access.
However, access returns some #Num errors. I need to convert several of the columns to text, from what I read by adding apostrophe. Is there a macro that I can run on certain columns that will add an apostrophe in front of all? There are 7000 lines, so doing it manually is not possible. Thanks |
#2
|
|||
|
|||
Golf, here is one way
Sub add_apostrophe() 'will add an ' in front of whats in the used range in column A Set rng = Intersect(Range("A:A"), ActiveSheet.UsedRange) For Each c In rng c.Value = "'" & c Next End Sub -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "GolfGal" wrote in message ... I download a .csv sheet daily, open & save as excel, and link to access. However, access returns some #Num errors. I need to convert several of the columns to text, from what I read by adding apostrophe. Is there a macro that I can run on certain columns that will add an apostrophe in front of all? There are 7000 lines, so doing it manually is not possible. Thanks |
#3
|
|||
|
|||
THANK YOU very much! That worked great!
"Paul B" wrote: Golf, here is one way Sub add_apostrophe() 'will add an ' in front of whats in the used range in column A Set rng = Intersect(Range("A:A"), ActiveSheet.UsedRange) For Each c In rng c.Value = "'" & c Next End Sub -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "GolfGal" wrote in message ... I download a .csv sheet daily, open & save as excel, and link to access. However, access returns some #Num errors. I need to convert several of the columns to text, from what I read by adding apostrophe. Is there a macro that I can run on certain columns that will add an apostrophe in front of all? There are 7000 lines, so doing it manually is not possible. Thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macro Formula revision? | Mark | Worksheet Functions | 1 | November 28th, 2004 01:43 AM |
Macro for multiple charts | JS | Worksheet Functions | 1 | November 19th, 2004 03:44 AM |
Save document without saving macro within it? | Dave Peterson | General Discussion | 0 | November 16th, 2004 11:42 PM |
Macro buttons ...help please | ttd | Worksheet Functions | 1 | March 26th, 2004 08:47 PM |