 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / August 2008Displaying text.
I have first and last names in a list and need to have excel pull only the first name. These names are all in the same column. I tried using LEFT but can't figure out how to have excel stop once it hits the space between the first and last name. -RaY Try this, assuming your combined name is in A1: =LEFT(A1,SEARCH(" ",A1)-1) Hope this helps. Pete > I have first and last names in a list and need to have excel pull only the > first name. These names are all in the same column. I tried using LEFT but > can't figure out how to have excel stop once it hits the space between the > first and last name. > > -RaY Maybe this dragged down =LEFT(A1,FIND(" ",A1)-1) Mike > I have first and last names in a list and need to have excel pull only the > first name. These names are all in the same column. I tried using LEFT but > can't figure out how to have excel stop once it hits the space between the > first and last name. > > -RaY Workd perfect. Thanks everyone. > Maybe this dragged down > [quoted text clipped - 8 lines] > > > > -RaY In B1: =LEFT(A1,FIND(" ",A1)-1) In C1: =RIGHT(A1,LEN(A1)-LEN(B1)-1)  SignatureGary''s Student - gsnu200800 > I have first and last names in a list and need to have excel pull only the > first name. These names are all in the same column. I tried using LEFT but > can't figure out how to have excel stop once it hits the space between the > first and last name. > > -RaY |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.