Search results for query: *

Guys: Actually I do import the data into Excel and, yes, I specify the data type to be text for my problematic date-like ID fields. And I never save it as an XLS but keep it as a CSV. Still, even after taking that precaution, when I link the CSV in Access (as a linked table), some of the...

Thanks for the tips. So, the loop suggestion sounds much smarter than my lengthy code. The file that I'm presently opening in Excel is a CSV that I run my macros against and it remains a CSV when I'm done. One of my databases has customer numbers that appear to be dates like 02-06-2312 and...

Wow, thanks Skip. Excellent!

Hello. I'm back. I'm not sure why, but I'm not getting notifications that there are replies to this thread. I checked my settings and it appears that I should get emails but nothing is coming thru. So, I apologize for not commenting sooner on the last remarks. So, one of my Excel macro has...

Yep, it is a *.csv. And I get out whatever our customers enter in. There is no functionality to fix the output before it becomes a *.csv. I need to standardize addresses to compare to existing records in our CRM to de-dupe and update or add new customer records. Right now, it's all done via...

Great tips. Thanks, guys. What I'm doing is correcting the output from a messy online contribution site. When entering their name and address, the donors enter all manner of bad abbreviations and iMpRoper cASE and I need my users to be able to rapidly update 1) mixed case to Proper or Title...

Gavona! Great tip. Thanks for the help. I modified just the last line from: rDestination.Value = rDestination.Value 'convert all but first row to values to: rDestination.NumberFormat = "@" to change the format to "text" because what I am doing is fixing zip codes that are exported from an...

Hello. I'm back again. And I'm a "him" (Steve). I have a subsequent question (you may have created a monster). I have entered a formula in the first cell of a column and I want to autofill that formula to the last row of data. But again, I want this to be a macro because I will reapply it to...

Andrzejek! I AM having fun. Your InputBox is great. I'm learning a lot. And I see why the TRIM wasn't working -- closing parenthesis in the wrong spot. Thanks again!

Guys, I have a follow-up question. Can I modify the code you supplied to apply to ANY column I select? I will want to change many different columns to Proper Case.

Thanks, Andrzejek! Sorry I posted in the wrong place. I wasn't thinking of it in terms of VBA but more using some special keystoke(s) while recording the Macro to do what you cleverly did in the Do While . But your answer is great. I will be able to use this solution in a number of places...

I get data output from an online application. Basically it’s name and address. Since the data is being entered by the general public, there are no standards as far as using Proper Case or Title Case in any of the fields especially the Address Field. I get the data in Excel and I fix it using...

Skip & jsteph: Sorry, I dropped off this string -- dragged into another project. And not exactly joy in Mudville but I'm plowing my way thru the data all over again. But your words of advice were greatly appreciated. SAW

Skip: Yep, I'm back to square one. And, as I mentioned, if I save the spreadsheet as *.txt the formatting all goes away. I did not create the original spreadsheets and there are 5 altogether from different sources, so who knows how they were originally formatted. But thanks for your help. I...

Skip: Nifty, but when I did as you suggested, the resulting number was not the original phone number in the original spreadsheet. For example, in ny original worksheet, the phone number appears as "3479631029" turns into "3.47963e+009" in my Access db and when I do the paste special I get...

Skip: Thanks for your spirited response. As a matter of fact, in the original Excel spreadsheet (I may not have been entirely clear) the phone field was "text". And, the field is also "text" in Access. I understand that Scientific Notation applies to numbers but why would it be applied to a...

Hello: I'm cleaning up a ton of data and I've imported a number of Excel spreadsheets into my database. One of the fields is "PHONE" and, after spending a lot of time fixing messy records, I see that many of my phone numbers have taken on some weird formatting. The original field in Excel was...

Guys: Thanks for this -- sooo much. I can't believe your solution(s) were so straightforward and easy. Much appreciated!

Hello: I need to import customer records into a database. I am given rows of data that looks like this: PREFIX;FNAME;MNAME;LNAME;ADDR1;ADDR2;CITY;STATE;ZIP;PHONE;EMAIL Mr.;John;M.;Smith;123 Main Street;Apt.4;Anytown;PA;18331;6106812323; Mr.;John;M.;Smith;123 Main...

cmeagan656! Sorry it took me so long to respond. My user was out of the office with her LT for the past day or so since I posted my problem. We are running Office 10 but your suggestion sent me in the right direction, and indeed, it was the "delegate" feature that was turned on. Thanks for...