• Home
  • About
  • Request

Separating First and Last Names in Microsoft Excel

By Unknown   Posted at  01:36   TRICKS 0 comments


Separating First and Last Names in Microsoft Excel

How to get the First Name 
=LEFT(A1,FIND(" ",A1,1)-1)

How to get the Last Name 
=RIGHT(A1,LEN(A1)-FIND(" ",A1))

TOPICS: , ,

Like This Post? Please share!

  • Share to Facebook
  • Share to Twitter
  • Share to Google+
  • Share to Stumble Upon
  • Share to Evernote
  • Share to Blogger
  • Share to Email
  • Share to Yahoo Messenger
  • More...
Avatar
Unknown

Tips and tricks that help make you more helpfull and your overall Enjoynment.... With these tips users can increase their productivity on the computer and make their overall computer experience a lot more enjoyable Below is a listing of categories containing all known computer tips and tricks.Below is a listing of categories containing all known TREND OF NEWGENERATION♥☺ 4CAREPC .

No comments :

Leave a Reply

Scroll to top