SpreadsheetWEB
  • Features
  • Pricing
  • Blog
  • Customers
  • 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...
Page 1 of 11

Recent Posts

  • Treemap Excel Charts: The Perfect Tool for Displaying Hierarchical Data
  • How to create a dynamic drop down list Excel using the UNIQUE and FILTER functions
  • Comparing the Performance of SpreadsheetWeb 6.11 with Google Sheets and the Microsoft Office 365 Excel API
  • How to create an Excel dynamic list or a table without helper columns using SEQUENCE
  • Function: ISEVEN
  • Function: ISODD
  • Function: ISREF
  • Function: ISNONTEXT
  • Function: ISTEXT
  • What’s New in SpreadsheetWEB 6.11

Product

  • Pricing
  • 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

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