
Tamamlandı
İlan edilme:
Teslimde ödenir
I’m working in Microsoft Excel 2016 on a single-sheet file whose FIRST, LAST and ADDRESS columns arrived in all caps. I need a clean VBA routine that scans only those three columns and converts every cell to Proper Case—keeping the first character as-is and lowering the rest—while leaving everything else untouched. Key points you must handle • FIRST, LAST, ADDRESS are the only targets; every other column must stay exactly as found. • Any cell that is already formatted correctly should be skipped, not rewritten. • ADDRESS cells begin with street numbers; those numbers (and any other non-alphabetic characters) must stay exactly the same. • The macro has to run in Excel 2016 without additional add-ins. Deliverables 1. A well-commented .bas or .xlsm file containing the macro. 2. A short note explaining how to import/run it and, if needed, how to adjust the target column names. That’s all—let me know if anything is unclear before you dive in.
Proje No: 40042519
45 teklifler
Uzaktan proje
Son aktiviteden bu yana geçen zaman 3 ay önce
Bütçenizi ve zaman çerçevenizi belirleyin
Çalışmanız için ödeme alın
Teklifinizin ana hatlarını belirleyin
Kaydolmak ve işlere teklif vermek ücretsizdir
45 freelancer bu proje için ortalama $107 USD teklif veriyor

Hi I have read the requirements and understand them. I can assure you that if you work with me once, you will always work with me on these kinds of projects. would you like to discuss the project with me?
$100 USD 1 gün içinde
7,4
7,4

Hello, Greetings of the day! I have a vast experience of working in Advanced Excel and I have completed many projects based on Advanced Excel. I have read your requirements and I can complete your project within time frame with proper and efficient work. I am a full time Freelancer and available to start your project immediately. I have an experience of below skills • Changing Raw Data into Presentable Data which can be easily under stood. • Use of Advanced Excel Formula • Data, Power Query, Tables & Formatting • Conditional Formatting • Advanced Charting • Pivot Tables & Pivot Reporting • VBA & Macros • Data Analysis • Anova analysis in Excel • Statistic & Modeling using Excel • Forecasting & Trend Analysis & many more …. I am ready to work on a Sample file also if required. Please initiate the chat so that we can discuss more about project and start the project. Thanks & Regards Sneh
$220 USD 2 gün içinde
6,1
6,1

Hi Brian, Thank you for considering my proposal. With over 8 years of real-world experience and freelance work in Excel, I am confident in my ability to assist you with your project. I have carefully reviewed your requirements for the Excel Proper Case Macro and I am eager to discuss this project further with you. I would like to connect with you in chat to delve deeper into the specifics of your project and ensure that I fully understand your needs. I believe that my expertise in Excel and VBA can help you achieve the desired outcome for this task. Looking forward to discussing this project with you. Regards
$30 USD 1 gün içinde
6,0
6,0

Hi! I am proficient in MS Excel, Google Sheets, Spreadsheet accounting, and its use in business and analysis. I can accurately enter, arrange, analyze, and present your data. Let's Connect
$250 USD 7 gün içinde
4,8
4,8

With a solid background in data entry, data processing and a whopping 7 years of experience specifically in excel macros and VBA, rest assured that your project is in capable hands. Upon understanding your requirements thoroughly, I have full confidence in delivering an effective and well-commented solution, tailored specifically to your needs. My expertise enables me to easily scan and manipulate Excel sheets using VBA code, without the requirement of any additional outside add-ons. I understand the sole focus should be on converting every cell in the FIRST, LAST and ADDRESS columns to proper case whilst keeping everything else intact. I will ensure not only that this is accomplished perfectly but any cells already formatted correctly will be skipped as requested. Deliverables wise, you can rely on me for clean .bas or .xlsm file containing the macro with easy-to-understand documentation guiding you through importation/running process, targeting your chosen address columns. Hire me for a precise result within an efficient timeframe! Feel free to reach out if you have further questions or need clarification on certain aspects of the project!
$49 USD 1 gün içinde
3,9
3,9

Hi there, I am A.R.M. MASUD, with a strong data science background. I specialize in creating customized Excel-based solutions that streamline business processes, enhance data management, and enable insightful analysis. Whether it’s developing advanced macros, automating workflows, or integrating Excel with other Microsoft applications, I deliver robust, efficient solutions tailored to your specific needs. My expertise includes AR/AP Management, Financial Statement Preparation, Expense Tracking, Budgeting and Forecasting, Cash Flow Management, and APR Calculation via the Sales Force Formula. I design and develop advanced Excel workbooks with tailored features such as formulas, macros, pivot tables, Power Query, mail merge, email via Outlook and Gmail, add-ins, customized macros, and automated repetitive tasks using Excel VBA. I also create interactive dashboards for real-time data visualization, providing fully functional and customized Excel workbooks, automated workflows, and macros for efficient task management and data integration between Excel and other business systems. https://www.freelancer.com.bd/projects/excel/Advanced-Data-Processing-Chart/reviews Thank you for considering your Microsoft Excel development project. I am confident that my expertise and commitment to excellence will add significant value to your business operations. Thanks A.R.M MASUD
$50 USD 2 gün içinde
3,9
3,9

Hello there, I’m a VBA and Excel specialist with eight years of experience automating data cleanup tasks like this. I can write a clean, reliable macro that targets only your FIRST, LAST, and ADDRESS columns on a single-sheet Excel 2016 file, converting text to Proper Case while leaving numbers, punctuation, and other columns untouched. The macro will: Detect the target columns by header name so it works even if column positions change. Skip cells already in Proper Case to avoid unnecessary rewrites. Preserve street numbers, punctuation, and non-alphabetic characters in ADDRESS. Run directly in Excel 2016 with no add-ins required. Deliverables include a fully commented .xlsm or .bas file and a brief note explaining how to import and run the macro, plus instructions on adjusting target column names if needed. I can prepare this quickly, ensuring it’s robust, easy to use, and safe for your existing data. Best regards, Mobasher Reza
$140 USD 3 gün içinde
3,9
3,9

Before I begin, would you like the Proper Case logic to preserve internal capitalization for names like “McDonald” or “O’Connor,” or should the routine strictly apply first‑letter‑upper and the rest lower for every word? Hello, I can create a clean and efficient VBA macro that converts only the FIRST, LAST, and ADDRESS columns to Proper Case while leaving all other columns untouched. The script will skip already‑formatted cells, preserve numeric and non‑alphabetic characters in addresses, and run smoothly on Excel 2016 without add‑ins. I’ll deliver a well‑commented BAS/XLSM file plus a short guide on importing, running, and adjusting target columns.
$160 USD 4 gün içinde
3,1
3,1

I can build a clean, Excel-2016-compatible VBA routine that fixes only your FIRST, LAST and ADDRESS columns with precise Proper Case logic, leaving all other data untouched. You’ll get a well-commented macro and simple instructions so you can reuse or adjust it anytime.
$30 USD 1 gün içinde
3,1
3,1

With your Excel Proper Case Macro project, you need an experienced freelancer who can handle data meticulously and with minimal disruption to other columns. As a seasoned data entry specialist with solid Excel skills, I am confident I can deliver exactly what you need. My seven years of experience have not only honed my Microsoft Excel skills but also my attention to detail is truly paramount. Crucially, I am well-versed in creating VBA routines, which will be vital for your task. Additionally, your project stipulates that the macro has to run without any additional add-ins - once more, I've got you covered. I am confident in delivering a well-commented .bas or .xlsm file containing the macro and even providing a short note on how to import/run it. Lastly, my diverse writing background and thoroughness would ensure a consistent format throughout the FIRST, LAST and ADDRESS columns while leaving the rest untouched - something we can talk about in the short note I provide. Trust me Zainab, I am your best bet for this project. Let's get started!
$80 USD 3 gün içinde
2,5
2,5

With my robust technical background spanning from front-end to back-end development, I have a wealth of knowledge in languages like VB and VBA which are essential for this project. Over the years, I have executed projects similar to yours - automating tasks on Excel using VBA macros. As an ace in Excel 2016 and its VBA editor, you can trust me to create a well-commented .xlsm file and short note providing clear instructions to import and run your Proper Case Macro. One fundamental aspect of macros is efficiency and that's something I always strive for. I understand the importance of ensuring that only the targeted columns, FIRST, LAST, and ADDRESS are altered while not affecting other cells or columns. Rest assured, my solution will strictly respect this requirement as well as maintaining characters exactly as they are, especially for the street numbers in the ADDRESS column. Lastly, as someone who values professionalism and timely delivery, I will ensure your project is completed promptly without compromising quality. My diverse skill set combined with my commitment to client satisfaction makes me the perfect fit for your needs. Let's dive into transforming your all caps text into proper case, because frankly, Excel shouldn't settle for anything less!
$140 USD 5 gün içinde
2,0
2,0

Hello there We can help you fix the FIRST LAST and ADDRESS columns with a clean VBA routine and we have years of experience handling technical tasks through Future Station so we can jump in fast. We will scan only those three columns in Excel 2016 convert them to proper case and keep all numbers and non alphabetic characters exactly the same. We will skip already correct cells and deliver a commented bas or xlsm file plus a simple note on how to run or adjust it. Do you have the file ready for us to review best regards Future Station
$150 USD 1 gün içinde
1,4
1,4

Hello, how are you? I've reviewed the description carefully and I am sure I can deliver this task on time because I have rich experience. I understand that you need a VBA routine to convert the FIRST, LAST, and ADDRESS columns in your Excel sheet to Proper Case, while keeping everything else untouched. I have hands-on experience in Excel VBA programming and macro creation. Here is my approach as follows: - I will create a macro that specifically targets only the FIRST, LAST, and ADDRESS columns and applies the Proper Case formatting. - I will ensure that cells already formatted correctly are skipped to avoid unnecessary rewrites. - I'll make sure that the ADDRESS cells retain their starting street numbers and any non-alphabetic characters remain intact. I am ready to start immediately and can deliver the result fast. I'd love to discuss in more detail. Best Regards.
$30 USD 7 gün içinde
0,0
0,0

Hey Brian B., I just finished reading the job description, and I see you are looking for someone experienced in Visual Basic, Data Entry, Excel Macros, Excel VBA, Data Processing, Excel and Visual Basic for Apps. This is something I can do. Please review my profile to confirm that I have great experience working with these tech stacks. While I have a few questions: 1. Are all these requirements? If not, please share more detailed requirements. 2. Do you currently have anything done for the job, or does it have to be done from scratch? 3. What is the timeline to get this done? Why Choose Me? 1. I have done more than 250 major projects. 2. I have not received a single bad feedback in the last 5-6 years. 3. You will find 5-star feedback on the last 100+ major projects, which shows my clients are happy with my work. Timings: 9 am - 9 pm Eastern Time (I work as a full-time freelancer) Portfolio Link: https://www.freelancer.com/u/syeds273 I will share with you my recent work in the private chat due to privacy concerns! Please start the chat to discuss it further. Regards, Sadia.
$30 USD 4 gün içinde
0,0
0,0

Hello Brian B., I hope this message finds you well! I understand that you're looking for a VBA macro to convert the FIRST, LAST, and ADDRESS columns in your Excel 2016 file to Proper Case while preserving their original formatting where necessary. I'm excited about the opportunity to assist you with this task! With extensive experience in Visual Basic for Applications (VBA) and data processing, I can create a clean and efficient macro that will specifically target the columns you mentioned. The macro will ensure that: - It only scans the FIRST, LAST, and ADDRESS columns, leaving all other data untouched. - Cells already formatted correctly will be skipped to maintain data integrity. - ADDRESS cells will retain their leading numbers and any non-alphabetic characters as specified. I will provide you with a well-commented .bas or .xlsm file containing the macro, along with a concise guide on how to import and run it. This will also include instructions on how to adjust the target column names if necessary. I believe my skills in Excel VBA and my attention to detail will ensure that your project is completed to your satisfaction. I look forward to the possibility of working together! Best regards, Marijo S.
$30 USD 1 gün içinde
0,0
0,0

With my strong proficiency in Excel and a deep understanding of how to efficiently manipulate data, I am confident that I am the ideal candidate for your Excel Proper Case Macro project. I recognize the value of preserving existing formatting while effectively transforming the necessary columns to proper case. I will ensure that only your FIRST, LAST, and ADDRESS columns are modified while leaving other columns undisturbed - maintaining your data integrity as per your specification. Furthermore, having worked extensively with VBA scripts in Excel against considerable datasets, I understand the need for clean and well-commented code. My experience guarantees that not only will you receive a properly functioning macro but also one that is easy to understand and adapt to any future needs that may arise. As a Data Scientist with a strong background in Python and SQL programming, I am well-versed in dealing with structured data and values. This makes addressing non-alphabetic characters at the beginning of street numbers within ADDRESS cells an absolute breeze for me. Finally, my interdisciplinary skills empower me to see beyond just data modification and help unlock unanticipated insights from your dataset along the way. Choose me for efficient, robust solutions on time.
$140 USD 7 gün içinde
0,0
0,0

Hi, I would like to grab this opportunity and will work till you get 300% satisfied with our work. I am a senior developer which have 5+ years of experience on Visual Basic, Data Processing, Data Entry, Excel, Visual Basic for Apps, Excel VBA, Excel Macros Let's discuss on chat! Regards
$140 USD 7 gün içinde
0,0
0,0

I can create a clean, Excel‑2016‑compatible VBA routine that scans only the FIRST, LAST and ADDRESS columns and converts each value to Proper Case while leaving all other columns untouched. The script will check each cell before rewriting so entries that are already in the correct format are skipped, ensuring no unnecessary updates. Address fields that begin with street numbers will be handled safely, preserving all numeric and non‑alphabetic characters exactly as provided. You will receive a fully commented .bas or .xlsm file containing the macro, plus a short guide explaining how to import it via the VBA editor and how to adjust the target column names if your sheet structure changes. The final routine will run without add‑ins and will be optimized for clean performance in Excel 2016. If you’d like me to begin immediately, feel free to share the sheet structure or sample columns so I can tailor the code precisely to your layout. Regards Karan R.
$175 USD 4 gün içinde
0,0
0,0

Hello Brian B. Hope you are doing well! This is Efan , I checked your project detail carefully. I am pretty much experienced with Excel VBA, Data Entry, Visual Basic for Apps, Data Processing, Visual Basic, Excel and Excel Macros for over 8 years, I can update you shortly. Cheers Efan
$100 USD 3 gün içinde
0,0
0,0

Hi! I’m very interested in this project. Your requirements for a clean, well-structured VBA macro that targets only the DEPAN, BELAKANG, and ALAMAT columns—and converts each cell to Proper Case while preserving numbers and other non-alphabet characters—are clear and definitely achievable in Excel 2016. I can create a well-commented .bas or .xlsm file that: • Processes only the specified columns • Skips cells already formatted correctly • Maintains all numeric and non-letter characters in the ALAMAT column • Runs smoothly in Excel 2016 without any additional add-ins I will also include a brief guide explaining how to import, run, and adjust the macro if you ever need to change the target column names. I’m ready to begin whenever you are and happy to clarify anything before starting. Looking forward to working on this!
$100 USD 2 gün içinde
0,0
0,0

Henderson, United States
Ödeme yöntemi onaylandı
Tem 30, 2009 tarihinden bu yana üye
$30-250 USD
$30-60 USD
$30-40 USD
$30-250 USD
$20-25 USD
$8-15 AUD / saat
$30-250 USD
₹600-1500 INR
$30-250 USD
$30-250 USD
£10-15 GBP / saat
$250-750 USD
$15-25 USD / saat
$25-50 USD / saat
$10-60 USD
€6-12 EUR / saat
₹37500-75000 INR
₹12500-37500 INR
$30-250 USD
$15-25 USD / saat
$3-10 NZD / saat
₹750-1250 INR / saat
$10-30 USD
₹600-1500 INR
$30-250 USD