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

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

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

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. "

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

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

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

I can do it for you quickly and exactly . Please contact me for saving your time and your money .

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

I can make a macro that will split the name into required fields. Mohsan

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!

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

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

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!

Hi, I have read the project description & fully concern about your requirement. I can start now if you hire me. Thanks.

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

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

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

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

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.

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.