SpreadsheetWEB
  • Home
  • Pricing
    • Cloud Pricing
    • Server Pricing
  • Applications
    • By Industry
      • Education
      • Insurance
      • Investment
      • Public Sector
      • Startups
    • By Department
      • Finance
      • Human Resources
      • Marketing
      • IT
      • Sales
    • By Type
      • Data Collection
      • Data Visualization
      • Online Calculators
      • Online Reports
      • Mobile Applications
  • Resources
    • Blog
    • Case Studies
    • Data Sheets
    • Demos
    • FAQ
    • Resources
      • Applications
      • Excel Tips & Tricks
      • Excel Formulas
      • Excel Macros
      • Templates
    • Tutorials
    • User Guide
    • Video Tutorials
    • Whitepapers
  • About
    • About Us
    • Contact Us
    • Services
    • Customers
    • Press Releases
  • Try For Free
  • Sign In
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...

Recent Posts

  • How to filter by using a formula in Excel
  • Function: CLEAN
  • Function: TRIM
  • Function: LEN
  • Radar Chart in Excel
  • How to generate random numbers in Excel
  • What’s New in SpreadsheetWeb 6.9
  • Pagos Announces the Release of SpreadsheetWEB 6.9 Introducing Support for Dynamic Array Formulas
  • How to customize AutoCorrect
  • Function: CODE
  • Facebook
  • Twitter

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