Find Jobs
Hire Freelancers

Excel Macro - Break Full Name Field into First and Last Name

$10-30 USD

Closed
Posted about 5 years ago

$10-30 USD

Paid on delivery
I am looking for an Excel Macro expert. I have a spreadsheet with multiple columns, one of those columns has a full name that may include first name, initials, other names and last name. I want a macro that will only pull out the first and last name.
Project ID: 18930999

About the project

36 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
36 freelancers are bidding on average $23 USD for this job
User Avatar
Hi, I can split the full name into first and last name using excel formula. Please send me the excel file to check. Let's start. Thanks
$30 USD in 1 day
4.9 (923 reviews)
8.1
8.1
User Avatar
Hi, can I check your file please ? as I need to know how with a macro I can detect that these are name and family name and ignore other things. Thanks
$29 USD in 1 day
4.9 (300 reviews)
7.7
7.7
User Avatar
Hi, I have good Microsoft Excel skills with years of experience as well as I have complete number of projects for Excel to manage data and sorting. You can check my profile feedback section and you will know what my client asking for my work. I am Alison certified for Microsoft Office and Microsoft Excel. So, you can Trust me for a Best output with complete satisfaction. Your work will be delivered well in advance with seamless communication & timely response until project is completed. As well as for any alternation and query we are available 24 x7. Looking forward for great business deal. "
$29 USD in 0 day
4.9 (296 reviews)
7.3
7.3
User Avatar
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel macro to pull the first name and last name from a names column. I have already implemented this macro in the past. I need to have a look at your Excel sheet to see if there is a pattern that my macro can use. I'm among the most experienced, and skilled Excel, and VBA developers on this platform. I have completed over 280 projects successfully in six years, and I feel confident in achieving your task as well. You're welcome to visit my page (https://www.freelancer.com/u/paris2785) and get an idea of who I am and what services I provide to my clients. I will charge you $30 and can deliver within a couple of hours (a single milestone to release once you're satisfied with the final result). I'm online from 8 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas
$30 USD in 0 day
4.9 (250 reviews)
7.5
7.5
User Avatar
Hi, I can confirm you that I will be able to complete your project with the highest quality and accuracy. No need to pay me anything if you are not satisfied with my work. I will be more than happy if I get the opportunity to work with you on this project. Please feel free to check my reviews here (https://www.freelancer.com/u/safiqulislam67.html). Best regards, Safiqul Islam
$20 USD in 1 day
5.0 (220 reviews)
7.1
7.1
User Avatar
Hello client I can write the macro for you which will get you first and last name into 2 separate cells/ columns. Kindly contact me and show me the data structure right now in the file. Roy
$30 USD in 1 day
4.9 (362 reviews)
6.9
6.9
User Avatar
I can do it for you quickly and exactly . Please contact me for saving your time and your money .
$25 USD in 1 day
4.9 (126 reviews)
7.1
7.1
User Avatar
Hello, I can give you a simple excel formula that breaks Full Name Field into First and Last Name. Please drop a PM if you’re interested. Best regards, Hoang
$15 USD in 0 day
5.0 (162 reviews)
6.9
6.9
User Avatar
I can make a macro that will split the name into required fields. Mohsan
$15 USD in 1 day
5.0 (88 reviews)
6.3
6.3
User Avatar
Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! From the Access, of course, familiar. Give me a chance to show what I can do!
$25 USD in 0 day
5.0 (133 reviews)
6.5
6.5
User Avatar
Hello, I am ready to discuss project with you. Being experienced in working on excel vba/formula extensively, based on that I can help you in getting work done. As I understand, using formula alone can get first and last name, however, can confirm better on checking actual data. I am available to start now and want to discuss more specific details. Looking forward to have further project discussion on chat. Thanks. Vimal Arora
$15 USD in 0 day
4.8 (111 reviews)
5.9
5.9
User Avatar
Hi! Thank you for taking the time to read my proposal, My name is Uriel Baray I am a VBA Excel Expert with several years of experience on the field, if you are so kind to take a look to my portfolio, I have some samples for you there. Please send me a message so we can discuss further details of your project
$25 USD in 1 day
5.0 (44 reviews)
5.7
5.7
User Avatar
Hi there! Have done this type of work before and am an excel expert. Please feel free to message me with additional details such as the data file to be worked on or with questions if any, thanks!
$25 USD in 0 day
5.0 (94 reviews)
5.7
5.7
User Avatar
Hi, I have read the project description & fully concern about your requirement. I can start now if you hire me. Thanks.
$20 USD in 1 day
5.0 (90 reviews)
5.3
5.3
User Avatar
Hi there, I Have Scraped Amazon, Aliexpress, Yellow Pages, Yelp, Zomoto Etc. I Have 500 GB Internet With 20 Mbps Speed. I Have 6 Systems. I can do it. I have done many related projects like this. If you are provide this work, it will help my career also. Give me a chance to do this. Waiting for your precious reply. Thank you. Please Check my mastery work at:- https://www.freelancer.in/u/Stephenrajs *Why you are choose me 1. 24/7 hours support 2. Quick response 3. Deliver on time 4. Smooth communication. I assure that I can satisfy you completely and want to have a long term relationship with you. Best Regards Stephenrajs
$30 USD in 1 day
4.9 (101 reviews)
5.2
5.2
User Avatar
Hello, I have read the project description and understood it. We can apply a formula which will split the data and then we can have the first name and last name only. Let me know if you want me to do it. Looking forward to working with you. Best Regards, Kuldeep Gera
$15 USD in 1 day
5.0 (33 reviews)
4.9
4.9
User Avatar
Hello dear client I am expert in excel spread sheet I have understand your project I will split name column into two columns first name and last name if you are interested in my service then please contact me for more details Kind regards Adilah
$30 USD in 1 day
4.7 (23 reviews)
5.1
5.1
User Avatar
Hi, the only way to extract First and last name is by extracting the first character until the first space for first name and extracting the last character position +1 until the last character of that column. If all full named are well separated by space (have no spaces in the first name and last name), then writing formula or macro is easy task to do
$10 USD in 0 day
5.0 (10 reviews)
4.1
4.1
User Avatar
I can do the job. Last name detection would be based on first word=first name and last word = last name? I can start right now if awarded. I'm an engineer with advanced working knowledge and experience in Excel and VBA including interaction between different software (Word, Excel, Powerpoint, Access, Outlook, MS Project, Autocad, pdf, CorelDraw, etc.), web scraping, Access DB design, management Dashboards, stock and financial worksheets, KPI's, proficient coder in VB.Net, C#, Python, JavaScript (google sheets), VB6.
$15 USD in 1 day
5.0 (20 reviews)
4.2
4.2
User Avatar
Hi About me & what I can provide - 5 Yrs. of Experience in EXCEL & VBA FORMATTING, PIVOT, SLICER, GRAPHS, CHART & FORMULAS Macro coding HIGH ACCURACY start working IMMEDIATELY.
$23 USD in 1 day
4.9 (25 reviews)
3.9
3.9

About the client

Flag of UNITED STATES
Ashburn, United States
4.9
81
Payment method verified
Member since Sep 11, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.