 |
 | 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 / July 2007Remove Characters Until a Specific Character is Reached
Have cells with First Last names in them - need last name only. How to delete all characters up to and inlcuding the first blank space from left to right. I am having difficulty because the length of the first name varies...  SignatureThanks so much =RIGHT(A1,LEN(A1)-SEARCH(" ",A1)) SignatureRegards, Dave > Have cells with First Last names in them - need last name only. How to delete > all characters up to and inlcuding the first blank space from left to right. > I am having difficulty because the length of the first name varies... This was exactly what I needed - worked great - Thanks, SignatureThanks so much > =RIGHT(A1,LEN(A1)-SEARCH(" ",A1)) > > > Have cells with First Last names in them - need last name only. How to delete > > all characters up to and inlcuding the first blank space from left to right. > > I am having difficulty because the length of the first name varies... I am trying this formula and it tells me that I have too few arguments. what am I doing wrong. SignatureLibby > =RIGHT(A1,LEN(A1)-SEARCH(" ",A1)) > > > Have cells with First Last names in them - need last name only. How to delete > > all characters up to and inlcuding the first blank space from left to right. > > I am having difficulty because the length of the first name varies... Post the *exact* formula you are trying. Here's another way to do the same thing: =MID(A1,FIND(" ",A1)+1,255) SignatureBiff Microsoft Excel MVP >I am trying this formula and it tells me that I have too few arguments. >what [quoted text clipped - 7 lines] >> > right. >> > I am having difficulty because the length of the first name varies... Works for me as written qwerty asdfgh in A1 =RIGHT(A1,LEN(A1)-SEARCH(" ",A1)) in B1 returns asdfgh Maybe you have missed something in your tyoing? Try copy/paste from here. Another method you may want to try is Data>Text to Columns>Delimited by space. Gord Dibben MS Excel MVP >I am trying this formula and it tells me that I have too few arguments. what >am I doing wrong. Thu, 17 May 2007 10:26:04 -0700 from Frosty 1234 <Frosty1234 @discussions.microsoft.com>: > Have cells with First Last names in them - need last name only. How to delete > all characters up to and inlcuding the first blank space from left to right. > I am having difficulty because the length of the first name varies... =MID(A1,1+FIND(" ",A1),999) This will fail if you have any middle names, but it will work with two-word last names like "de Souza". SignatureStan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ Tried this too and works as well - except of course on those with middle names. Really appreciate the fast response. SignatureThanks so much > Thu, 17 May 2007 10:26:04 -0700 from Frosty 1234 <Frosty1234 > @discussions.microsoft.com>: [quoted text clipped - 6 lines] > This will fail if you have any middle names, but it will work with > two-word last names like "de Souza". |
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.