For teams that run on HubSpot
HubSpot full name split into first and last
Forms, scanned cards and imports often deliver the whole name in one field. HubSpot then keeps it as the first name, so emails open with the full name, and names written family name first, as in Japan, come out the wrong way round.
How it goes today
- Export the contacts with a full name in one field.
- Split them with a formula in a spreadsheet.
- Fix double names and prefixes such as van der by hand.
- Import the file back into HubSpot.
How it can go
Names that arrive in one field are split into first and last name.
Each night contacts with a full name in the first name, or in a field you name, are split into first and last name. Prefixes such as van, de or von stay with the last name, and the family name comes first for the countries you choose. Names the tool is unsure of are left alone and sent to you as a short list.
Say this in ChatGPT, Claude or Copilot
Your chat gets connected to Hypamoon first, with this request filled in. You paste your HubSpot key in the portal, never in the chat.
With Hypamoon, each night, find contacts in our HubSpot whose whole name is in the first name or in the field I name, and split it into first and last name, keeping prefixes like van, de and von with the last name and putting the family name first for the countries I give. Send me the ones you were unsure of.
A super admin creates the HubSpot service key under Development, Keys, and picks what it may read and change. It stays yours.
More for teams on HubSpot
- I merge duplicate contacts one by one.
- I clear old tasks by hand after a deal or ticket closes.
- I clone won deals by hand to set up the renewal.
- I change our workflows every time someone goes on holiday.
- I compare last week's deal export with this week's to see what changed.
- I work out our ticket times in business days in Excel.
- I add the contacts of a company to each new deal by hand.
- I export our HubSpot reports to send to people without a login.
- I take our own test entries off the form counts every month.
- I move contacts to another company one by one.
- I calculate our stage conversion rates by hand.
- I copy notes and calls out of HubSpot record by record.
- I move open tasks by hand when records change owner.
- I check by hand which won deals have no products.
- I clean up names, countries and company fields in HubSpot every week.
- I go through the pipeline by hand to find deals that went quiet.
- I calculate commission from HubSpot exports in a spreadsheet.
- I export each object from HubSpot by hand to keep a copy.
- I add the country code to phone numbers by hand.
- I set the subscription by hand for people who already confirmed.
- I track the time zones of my contacts in a spreadsheet.
- I write the formal greeting by hand for each contact.
- I cannot show what a form said when someone signed up.
- I type our exchange rates into HubSpot by hand.
- I rename product lines by hand on quotes in other languages.
- I check customer VAT numbers by hand on the VIES site.
- I add the VAT rate by hand to each line.
- I rebuild HubSpot invoices elsewhere to send an e-invoice.
- I make our invoices again elsewhere to get a Factur-X file.
- I link branch records to their parent company one by one.
- I look up each customer's prices and change the deal lines by hand.
- I keep the reseller and end user in text fields on each deal.
- I build our Gift Aid claim in a spreadsheet from HubSpot exports.
- I export HubSpot to a spreadsheet every week.
- I copy deal details into our contract template by hand.
- I tick off event attendees by hand from a list.
- I keep a branch per postcode in our workflow to route leads.
- I number our deals by hand from a counter in a spreadsheet.
- I work out renewal and follow-up dates by hand.
- I keep prepaid hours in a spreadsheet next to our tickets.
- I print the notification email to keep a copy of each form.
- I copy NPS scores from another survey tool into HubSpot.
- I work out deal margins in a spreadsheet.
- Everything for HubSpot