SpreadsheetWeb
  • Features
  • Pricing
  • Blog
  • Customers
  • Try For Free
  • Sign In
    • Customers
    • Trial Users
Select Page
How to get the first name text from the full name data

How to get the first name text from the full name data

by Ilker | Apr 9, 2018 | Excel Tips & Tricks

One perfect example of automatically cleaning up data in Excel is when working with name fields. You can separate first and last names (or actually any text with spaces) using this method. Syntax =LEFT(Full name, FIND(” “, Full name) – 1) Steps Begin by...
Page 1 of 11

Recent Posts

  • What’s New in 6.18: Formula Override and Advanced Data Filters
  • Pagos Announces the Release of SpreadsheetWeb 6.18 with Formula Override and Advanced Data Filters
  • STANDARDIZE Function
  • How to normalize data in Excel
  • Building a COVID-19 Dashboard in Excel
  • Tracking COVID-19 Data in Excel using Power Query
  • SpreadsheetWEB named one of the “5 Best Application Development Tools” by GetApp
  • How to create an Excel map chart
  • How to embed Bing Maps in Excel
  • How to disable Workbook_Open and Auto_Open in Excel

Product

  • Features
  • Pricing Old
  • Demos
  • Customers

Support

  • User Guide
  • FAQ
  • Tutorials
  • Training Videos
  • Case Studies
  • Data Sheets
  • Whitepapers

Resources

  • Blog
  • Excel Applications
  • Excel Tips & Tricks
  • Excel Formulas
  • Excel Macros
  • Excel Templates

About

  • About Us
  • Contact Us
  • Services
  • Press Releases
  • Facebook
  • Twitter

© Pagos, Inc. - All rights reserved - Privacy Policy - Terms of Use