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

  • Excel Database Functions
  • Forecasting in Excel
  • How to make Excel change case to uppercase using VBA
  • How to remove characters in Excel using VBA
  • How to have Excel convert formula to value using VBA
  • How to delete all named ranges with #REF Excel errors using VBA
  • All You Need to Know for Using Excel Iterative Calculation
  • How to compare two columns in Excel using VBA
  • How to spell check in Excel using VBA
  • How to display cell formulas in Excel that contain errors using VBA
  • Facebook
  • Twitter
  • Linkedin

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